How do I convert text to columns when there is a carriage return?

G

Guest

The data comes in as wrapped text. See below. After reformating to unwrap,
a symbol appears but will not let me copy it to use as "delimiter - other".

"Conv. Clear Regular
Albuquerque NM
Net
Conoco b"
 
B

Bernie Deitrick

Stumped,

Use Data | text to columns, delimited, other, and in the other box, hold
down the ctrl key, and type 0010 on your numeric keypad.

HTH,
Bernie
MS 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

How do I separate wrap text in excel spreadsheet? 2
Carriage return symbol - how to split columns at 6
How do I remove carriage returns from a cell 3
How do I unwrap text to columns? 2
carriage return that works when pasted into a text file (eg. Notep 3
How do I get carriage returns to not be row delimiters in text fi. 1
How to insert carriage return in the middle of a text formula to . 2
How do I convert text to "proper text"? 1

Top