Use the first word only

  • Thread starter Daniel - Sydney
  • Start date
D

Daniel - Sydney

Hi

I have Excel 2003 SP2

I have a column with product names, the column is 4,000 rows long.

The products are between three and seven words long but I only need the
first word, how do I extract the first word only.


thanks

Daniel
 
J

Joel

Put in an auxilary column in Row 1 and copy down through all rows

=LEFT(A1,FIND(" ",A1)-1)
 
Top