Is there a way to enter a tab in a cell?
--
Leah L. Hinds
Project Manager, Training & Support

Not really.

You could use a formula:

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

But that won't look pretty.



leahl wrote:

Is there a way to enter a tab in a cell?
--
Leah L. Hinds
Project Manager, Training & Support

--

Dave Peterson

You can try char(9).

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


If this post helps click Yes
---------------
Jacob Skaria


"leahl" wrote:

Is there a way to enter a tab in a cell?
--
Leah L. Hinds
Project Manager, Training & Support

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


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112454

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!
--
Leah L. Hinds
Project Manager, Training & Support


"jamescox" wrote:


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


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112454