View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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