View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wjohnson
 
Posts: n/a
Default Cell Limitations ? Formatting and Size when exporting to Tab based Text file?


You cannot have any "forced returns", "forced line breaks."
When EXCEL "sees" a forced return or line break - it will add anything
following the line into a NEW CELL.
In WORD you can do a FIND and REPLACE, use ^p for carriage returns
(paragraph marks) and ^l for a forced line break. You can also find
these in the REPLACE Menu, under the MORE-SPECIAL tab.
In the replace box just hit the spacebar - and this will insert a
space.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=522835