Academic journal article Journal of Accountancy

Split an Excel Cell and Enter Two Pieces of Information

Academic journal article Journal of Accountancy

Split an Excel Cell and Enter Two Pieces of Information

Article excerpt

Q. I've seen spreadsheets that contained a cell with a slash mark (/) dividing it so it could contain two different pieces of information--for example, a number on one side of the slash and another number or a word on the other side. How can I do that?

A. Oddly enough, it's done with the Format command as a display function; and for that reason it's not the kind of data Excel can calculate. Let's say you want a cell to contain two words, High and Low, separated by a slash. Begin by putting your cursor in the target cell and click on Format, Cells and Border and then select the diagonal box in which the slash mark rises from the lower left to the upper right (see screenshot below).

[ILLUSTRATION OMITTED]

Type your two words into the cell--High and Low. The words also will appear on top of your screen in the Formula box (see screenshot below). …

Search by... Author
Show... All Results Primary Sources Peer-reviewed

Oops!

An unknown error has occurred. Please click the button below to reload the page. If the problem persists, please try again in a little while.