View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default Text to columns delimited by carriage return

In the second step after choosing delimited, select other, put the cursor in
the box and hold down alt while typing 010 on the numpad, release alt


--

Regards,

Peo Sjoblom

"EMG03" wrote in message
...
I have a column where each cell has values that are separated by a

carriage
return, and I want to do a Text to Column action delimited by the carriage
returns. What is the best way to do this?