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


.