tab character not work

  • Thread starter Thread starter SamuelXiao
  • Start date Start date
S

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