Hard breaks in text to soft breaks in Excel

  • Thread starter Thread starter tbailey
  • Start date Start date
T

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?!!!!! :-
 
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.
 
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]...
 
Back
Top