View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default question on horizontal tab

Try formatting the cell: Format | Cells -Alignment and check the "Wrap
Text" box
I assume the "/t" is correctly inserting a CHAR(10)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"wcc" wrote in message
ups.com...
Hello,

When putting a string into a clipboard (which can be later pasted into
Excel), what do I need to use to represent the horizontal tab? I
thought "\t" is the answer, but it doesn't work. It shows as a square
box instead of splitting data into multiple columns. Thank you!

--
wcc