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.

 

MANAGEMENT ACCOUNTING

Developing finance leaders

A good leader recognizes that part of the job is developing the next generation of leaders. Veronica McCann, CGMA, a former division CFO at Commerzbank in Singapore, shares tips on developing future finance leaders.

PROFESSIONAL ISSUES

Belicia Cespedes: A CPA at 17

Through hard work and determination, Belicia Cespedes earned the credential before she was even eligible to vote.

SPONSORED REPORT

How to audit high risk areas

Revenue recognition, internal control over financial reporting, accounting estimates and going concern are areas of audit that have emerged as particularly challenging and complex.