Carriage return symbol - how to split columns at

[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?

 

[Gord Dibben]

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

 

[Guest]

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.

 

[Gord Dibben]

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

 

[Dave Peterson]

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!)

 

[Gord Dibben]

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

 

[Dave Peterson]

And we all know how painful that can be!