Thread: text to columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PH NEWS
 
Posts: n/a
Default text to columns

I have found a way of doing this and thought I would post to help others. As
far as I can see there is no way to operate a text to columns function using
Alt+Enter as a separator, so you have to start by changing the line feeds
into something else. So it's a find and replace.
EditFind
hold down Alt and type 010 release the Alt key. Replace with ",". Now you
can use text to columns.




"PH NEWS" wrote in message
...
Hi all

Can I do a text to columns using {lf} (line feed), Alt+Enter as the
separator?

Thanks in advance for any help

SPL