CHAR() help

[Steve H]

I am trying to do a "TAB". I can't find a CHAR() for
it. I know that a new line is CHAR(10). Can anyone help
on this?

Thanks

 

[Gord Dibben]

Steve

CHAR(9)

What are you trying to accomplish that would require a "TAB" character?

You can't force a TAB in a cell like you do a New Line.

Gord Dibben Excel MVP

 

[Frank Kabel]

Hi
CHAR(9)

 

[Steve H]

Gord,

Thats what I want to do... Tab text in a cell. Are there
any good alternatives?

 

[David McRitchie]

What is what you are trying to do, you can't use
a TAB within a cell in Excel

 

[Dave Peterson]

="Some text"&rept(" ",8)&"More text"

will insert 8 space characters. Doesn't look too bad in a fixed width font like
Courier New, but not to good in a proportional font like Arial.