how to copy the first word or two words from a cell containing a c
Wow, thanks guys, any idea how to adapt this to do the first 3 and 4
words?
Thanks again.
On 28 Jan, 17:37, Teethless mama
wrote:
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
|