Tabbing within a cell

D

Dave Peterson

Not really.

You could use a formula:

="some text" & char(9) & "more text"

But that won't look pretty.
 
J

Jacob Skaria

You can try char(9).

="Field1" & char(9) & "Field2" & char(9) & "Field3"


If this post helps click Yes
 
J

jamescox

Well, the answer is "Yes", but it's probably not what you want.

In cell formulas, Char(9) evaluates to a Tab, but it will appear as a
hollow box in Excel. If you copy and paste it to an application that is
'tab aware' - say Notepad, you will see a tab.

However, if you copy what you just pasted into Notepad and paste it
back into Excel, anything to the right of the tab goes into the next
cell - that's because Excel treats tabs as a command to move to the next
cell.

BTW, the Concatenate function is a good way to get tabs and other
'non-printing ASCII characters' into text strings, but as you see, what
you get may not be what you expected or wanted...
 
L

leahl

Thanks to all of you. I will try all ways. I knew I could get a great
answer! Even if it is not the exact one I wanted. Thanks again!
 
Top