separate columns

M

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
 
F

Frank kabel

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