problem with Data|Text to Columns

  • Thread starter Thread starter P D Sterling
  • Start date Start date
P

P D Sterling

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
 
P D Sterling said:
call data parsing, does not work correctly. I have to divide the columns
with one extra space,
Click to expand...

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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
 
Back
Top