Split An Excel Cell And Enter Two Pieces Of Information

BY STANLEY ZAROWIN

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.

 

SPONSORED REPORT

Post-busy season checklist

Now that tax season is over, pause for some introspection to guarantee that next year’s busy season is even better. Bonus: “Dirty dozen” scams list to share with your clients. Sponsored by Thomson Reuters, Bloomberg BNA, Bloomberg BNA // Software and Wolters Kluwer.

QUIZ

News quiz: Risks are top of mind in finance

Americans are worried about risks to their financial security. Accountants also see risks to their organizations and their careers. See how much you know about recent news and reports with this quiz.

CHECKLIST

Auditing risks in culture

Cultural flaws can seriously damage an organization. Here’s how internal auditors can reduce risks by embedding culture audits into existing audit programs.