Try this...

A1 = try this out

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

Returns: try

--
Biff
Microsoft Excel MVP


"Daniel - Sydney" wrote in message
...
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