Select the cells in the column that you wish to "separate", then:

<Data <TextToColumns

Make sure that "Delimited" is checked, then <Next,

Then click in "Space", and you'll immediately see in the DataPreview window,
just how your data will be separated.

Click <Next again, and in this window you can decide on exactly what to do
with the data.

First of all, in the "Destination" box, you see the default *start* location
for the separation.
This is the actual column that *now* contains your data, meaning that your
original data will be *replaced* with the first column of separated data.
If you wish to retain the original datalist, you can change the destination
of the separated data to any column or row you wish.

Next, you can pick and choose to which of the separated columns you actually
wish to "save and/or move".

Let's say in your case, with the original data in Column A, you only want
the third column of separated data to be printed into Column D.
Click in the first column of the DataPrieview window, selecting it (black),
then click on "Do Not Import Column".
You'll see the column header change to "Skip Column".
Then click in (select) the second column, and *again* click on "Do Not
Import Column", skipping that one also.
Change the address in the "Destination Box" to D1, and finally click on
<Finish.

One of the advantages of using this feature is, that when you're finished,
you have true data, and *not formulas* that are only returning data, where
you might have to go through additional steps and procedures to eliminate
the formulas to leave the data behind.
--

HTH,

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


"Joe" wrote in message
...
Hello
how do you do datatext to columnsdelimitedspace?

Thanks

-----Original Message-----
You could use datatext to columnsdelimitedspace or
A formula solution
=MID(A1,FIND("$",SUBSTITUTE(A1," ", "$", LEN(A1) - LEN
(SUBSTITUTE(A1," ",
""))))+1, 255)

--
Don Guillett
SalesAid Software

"Joe" wrote in
message
...
I have three words per cell, and a whole list of cell.
I want to pick up the last word in the cell only and
put
it in another cell.
Each cell/word has a diffent number of charachers so i
cant use the MID function
does anybody have any ideas
Thanks


.