Use the first word only
 

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

Use the first word only
 

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

Use the first word only
 

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

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

"Daniel - Sydney" wrote:

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

Use the first word only
 

Thanks to Joel and T. Valko

"T. Valko" wrote:

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

Use the first word only
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Daniel - Sydney" wrote in message
...
Thanks to Joel and T. Valko

"T. Valko" wrote:

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