View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Take first word out of cell and put it in a new cell

You can't do that with a formula, you would need VBA, macro code.

--
__________________________________
HTH

Bob

"LM" wrote in message
...
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?