Thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mike" wrote in message
...
RD:

Thanks so much. This worked like a champ.


-----Original Message-----
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!
==============================================

"Mike" wrote in
message
...
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?

.