Thread
:
Select part of a cell
View Single Post
#
2
Don Guillett
Posts: n/a
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
Reply With Quote