tab character not work

[SamuelXiao]

Hi all,
I want to insert tab space in a cell so I tried: ="Hello ," & CHAR(9)
& "world", but it will still get "Hello,world" instead of
"Hello,___world" (___ is the tab space). In vba, I tried using vbTab,
but it is still not working.
Do anyone know how to insert a tab in either cell or vba? I am using
Excel 2007.

Any help would be appreciated.

 

[Dave Peterson]

Tab characters don't work like they do in MSWord. (You should be seeing a
little square where that tab character is, though.)

Maybe you can either use spaces--or create a table in MSWord, where you can use
all these kinds of word processing features.

 

[Bob I]

Replace "tab" with a number of spaces actually desired.

 

[SamuelXiao]

Replace "tab" with a number of spaces actually desired.





- Show quoted text -

Thanks all, it is solved.