how to copy the first word or two words from a cell containing a c
Copy one word
=LEFT(A1,FIND(" ",A1)-1)
Copy two words
=LEFT(A1,FIND(" ",A1,FIND(" ",A1)+1)-1)
"jonny" wrote:
Hi there,
I have a lot of cells containing descriptions of items - I need to
copy the first 1 or 2 words from each cell into another cell.
Any ideas greatly received!
Thank you,
Jonny
|