Use the first word only

  • Thread starter Thread starter Daniel - Sydney
  • Start date 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
 
Put in an auxilary column in Row 1 and copy down through all rows

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I extract the only second word? 6
Need Help with Double Vlookup 4
Change all text on Spread sheet 1
Excel currency format does not translate correctly in a Word merge 2
Sort by Every Other Row? 0
how can I add an * to be the last character in a cell 3
Macro Question 3
How do I combine these columns into one? 2

Back
Top