Hard breaks in text to soft breaks in Excel

[tbailey]

Hi,

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

Is there any easy way to do this?

Please help?!!!!! :-

 

[Tom Ogilvy]

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.

 

[Tim Williams]

If you really meant soft breaks instead of hard breaks then look at
Replace()

eg

strContent = Replace(strContent, chr(10),"")
strContent = Replace(strContent, chr(13),"")

Tim.


in message
news:[email protected]...