problem with Data|Text to Columns
 

I wrote a while back and was possibly not clear - I do a lot of data
import and clean up - on this new computer, the subject topic, which I
call data parsing, does not work correctly. I have to divide the columns
with one extra space, which I never had to do before. I hate to think of
uninstalling excel, but if that's what it takes . . .

Any advice would be gratefully appreciated. Happy New Year
--

Regards,

P D Sterling
New York, Texas & Texas, New York

problem with Data|Text to Columns
 

P D Sterling" wrote in message
...
call data parsing, does not work correctly. I have to divide the columns
with one extra space,

One possibility is that the imported data now contains non-breaking spaces,
Character(160)

To check, with data that does not respond to Text to Columns arranging, in
say A1, enter in another call:

=SEARCH(CHAR(160),A1)

If it returns a number then you have a non-breaking space, if you get
#VALUE! then you don't.

If you do have a non-breaking space then try Text to Columns w5th both space
and other ticked in the second step and in the *other* box enter 0160 with
the Alt key held pressed. Note: the 0160 *must* be entered from the number
pad *not* the numbers above the letters.

This should separate the words whether they have spaces or non-breaking
spaces.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"P D Sterling" wrote in message
...
I wrote a while back and was possibly not clear - I do a lot of data import
and clean up - on this new computer, the subject topic, which I call data
parsing, does not work correctly. I have to divide the columns with one
extra space, which I never had to do before. I hate to think of
uninstalling excel, but if that's what it takes . . .

Any advice would be gratefully appreciated. Happy New Year
--

Regards,

P D Sterling
New York, Texas & Texas, New York

problem with Data|Text to Columns
 

this is a great idea, and I will test it out immediately. many thanks
and Happy New Year

Regards,

P D McIntosh Sterling
New York, Texas & Texas, New York


Sandy Mann wrote:
P D Sterling" wrote in message
...
call data parsing, does not work correctly. I have to divide the columns
with one extra space,

One possibility is that the imported data now contains non-breaking spaces,
Character(160)

To check, with data that does not respond to Text to Columns arranging, in
say A1, enter in another call:

=SEARCH(CHAR(160),A1)

If it returns a number then you have a non-breaking space, if you get
#VALUE! then you don't.

If you do have a non-breaking space then try Text to Columns w5th both space
and other ticked in the second step and in the *other* box enter 0160 with
the Alt key held pressed. Note: the 0160 *must* be entered from the number
pad *not* the numbers above the letters.

This should separate the words whether they have spaces or non-breaking
spaces.