separate columns

[marksuza]

Hi,

I am having a little problem and I was wondering if any of you coul
help me with it. I have two columns, A (Definitions) and B is empty.
Column A has several words in a single cell, I was wondering if ther
is a way to put only the first word from cell A1, for example, in cel
B1. Thanks.

Regards,

Marco

 

[Norman Harker]

Hi Marcos!

Try:

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

 

[Frank kabel]

Hi
enter the following in B1:
=LEFT(TRIM(A1),FIND(" ",TRIM(A1))-1)
and copy this down

 

[marksuza]

Works good, thanks norman.

Mar