Take first word out of cell and put it in a new cell
Thanks Bob, but that only copies the word. I want to cut it out of the cell
rather than copy it. Any other suggestions?
Lyn.
"Bob Phillips" wrote:
=LEFT(A1,FIND(" ",A1)-1)
--
__________________________________
HTH
Bob
"LM" wrote in message
...
I have a list of data and I want to remove the first word of each cell in
one
column and put it in a separate column. Is there a formula for this?
|