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

Click-through nexus: Pushing the boundaries of sales tax compliance

Sales and use tax compliance has been complicated by nexus expansion. In this report, we provide an overview of this issue and include a handy state-by-state summary of click-through nexus or notification requirements.

QUIZ

News quiz: Making allowances for the kids and the economy

Recent news gives CPAs insight into Americans’ attitudes about children and money and gauges outlook on the economy. 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.