Text to columns delimited by carriage return

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
In the "delimited by" enter ALT + 0010(from the numpad)

Alternative might be ALT + 0013


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting text divided by carriage returns 2
Carriage returns in the formula bar? 4
Excel: How to insert carriage returns in a formula to manipulate t 1
Parse Before Line Break 3
Removing carriage returns from excel 9
Unicode text and carriage returns 4
Split data around a carriage return 10
Strip carriage return, add row 18

Back
Top