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?
--
I know enuff to be dangerous.

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?

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.
--
I know enuff to be dangerous.


"Gord Dibben" 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?

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?

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

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

On Fri, 16 Feb 2007 19:28:16 -0600, Dave Peterson
wrote:

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?

And we all know how painful that can be!

Gord Dibben wrote:

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