Carriage return symbol - how to split columns at

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

Guest

I opened a CSV file that included a small box between data sets. I'm guessing
thes boxes are carriage return symbols. I want to split the text into columns
at each carriage return / box. Doing a cut & past into CRTL-F or CRTL-H
doesn't help, nor does using delimited as the setup in the text to columns
dialog box. Suggestions?
 
What are you using in the Text to Columns "other" box?

Alt + 0010 or 0013(entered on the NumPad) usually works.


Gord Dibben MS Excel MVP
 
I used alt 0010 based on another message I found after I posted this one
(sorry). doing that deletes everything to the right of the symbol. Not good.
 
Situation resolved.

RealGomer sent me the workbook today.

Was very strange doin's here.

The box character was char 0013

Ran Chip Pearson's CellView add-in to see the char 0013

Could not get Excel to recognize it as a de-limiter or to find using Edit>Find.

I ran a macro to change it to char 0010 and Data>Text to Columns did the job.

Double-stepping I know but Alt + 0013 just refused to be recognized.


Gord
 
I've never been able to get alt-0013 to work in either edit|Find or data|text to
columns (as the other delimiter).

Every time I've read your messages that say it works, I wonder what's wrong with
me <vbg>.

(Too many things to list--before anyone jumps in!)
 
I seem to reccomember 0013 working at one point but not cannot get it to be
recognized any more.

Maybe it was version specifiic like 97 or somesuch?

The alternative is............my reccomemberer has a synapse blown.


Gord
 
Back
Top