View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
jonny jonny is offline
external usenet poster
 
Posts: 11
Default 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