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.


"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