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 wrote:

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 EditFind.

I ran a macro to change it to char 0010 and DataText to Columns did the job.

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

Gord

On Mon, 12 Feb 2007 11:57:16 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

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


On Mon, 12 Feb 2007 11:05:01 -0800, RealGomer
wrote:

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?

--

Dave Peterson