Text To Columns
 

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?

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?

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?

.

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?

.