Split An Excel Cell And Enter Two Pieces Of Information


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).

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).

Once the words and the diagonal are in the cell, you have to adjust the position of the words: move High up and Low down. To do that, highlight the word you want at the top of the cell— High —and click on Format , Cells and then on the Font tab. Now, under Effects , click on Superscript ; notice when you click on it, the letters in the adjacent Preview box move up. Click on OK .

Do the same with the word Low. Only this time, when you get to Effects , click on Subscript and the Preview letters will move down. You’ll probably have to tinker a bit with the position of the words in the Formula box to get them to line up properly.



Why cybercriminals are targeting CPAs

This free report expands on the most commonly found scams, why education and specialized IT knowledge help to lessen security vulnerabilities, and why every firm should plan carefully for how it would respond to a breach.


How tax reform — and Excel — are changing the CPA Exam

Mike Decker, the vice president of examinations at the AICPA, discusses changes being made to the exam as a result of tax reform — and about how Excel will now be available for use on the test.