Text To Columns

[Mike]

I have imported what appears to be text data into a
worksheet. I have formated that data as text. I have used
the TRIM function on this data as well.

When I perform a text to columns function on this data
nothing happens. The delimiter I use is Space and these
are spaces in this text string.

Any thoughts?

 

[RagDyer]

As soon as you mention "import", the chances are very good that the "space"
that you see is not a normal CHAR(32) space that is produced with your
spacebar.
You probably have a CHAR(160) "non-breaking space".

When you use TTC, instead of clicking in the space box, click in the "other"
box and enter:
<Alt> 0160
Using the numbers from the num keypad, *not* the numbers under the function
keys.
However, be aware that you will *not* see anything displayed in the "other"
box, but it's there anyway.

When you look in the "Data Preview" window, you should see your separation
displayed.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have imported what appears to be text data into a
worksheet. I have formated that data as text. I have used
the TRIM function on this data as well.

When I perform a text to columns function on this data
nothing happens. The delimiter I use is Space and these
are spaces in this text string.

Any thoughts?

 

[Mike]

RD:

Thanks so much. This worked like a champ.

 

[Ragdyer]

Thanks for the feed-back.