View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Hard breaks in text to soft breaks in Excel

Alt+enter isn't a softbreak. It is a hard break. As long a workwrap is
applied the text will break at the point as a minimum.

--
Regards,
Tom Ogilvy

"tbailey" wrote in
message ...

Hi,

Am importing data into Excel from raw text files. Text files contain
'hard' line breaks, but I need all data to be in a single cell with
'soft' line breaks... ie alt+Enter...

Is there any easy way to do this?

Please help?!!!!! :-)


--
tbailey
------------------------------------------------------------------------
tbailey's Profile:

http://www.excelforum.com/member.php...o&userid=25566
View this thread: http://www.excelforum.com/showthread...hreadid=389990