return 1st word in string
 

is it possible to search a column (A)
and copy the 1st word of each cell to (B)

A B
Dopper Zulu = Dopper
Korma Xhosa = Korma

return 1st word in string
 

=LEFT(A1,FIND(" ",A1)-1) and copy down.
--
Gary''s Student - gsnu200802

return 1st word in string
 

Assuming first word is followed by an space in all cells
then you can enter the following in B1 and copy down;
=LEFT(A1,FIND(" ",A1))

"EngelseBoer" wrote:

is it possible to search a column (A)
and copy the 1st word of each cell to (B)

A B
Dopper Zulu = Dopper
Korma Xhosa = Korma

return 1st word in string
 

On Sun, 7 Sep 2008 02:56:20 -0700, EngelseBoer
wrote:

is it possible to search a column (A)
and copy the 1st word of each cell to (B)

A B
Dopper Zulu = Dopper
Korma Xhosa = Korma


Assuming that there is always at least one space in the cells of
column A you can try the following formula:

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

Copy down as far as needed.

Hope this helps / Lars-Åke

return 1st word in string
 

thanks

"Gary''s Student" wrote:

=LEFT(A1,FIND(" ",A1)-1) and copy down.
--
Gary''s Student - gsnu200802

return 1st word in string
 

thanks

"Sheeloo" wrote:

Assuming first word is followed by an space in all cells
then you can enter the following in B1 and copy down;
=LEFT(A1,FIND(" ",A1))

"EngelseBoer" wrote:

is it possible to search a column (A)
and copy the 1st word of each cell to (B)

A B
Dopper Zulu = Dopper
Korma Xhosa = Korma

return 1st word in string
 

thanks

"Lars-Ã…ke Aspelin" wrote:

On Sun, 7 Sep 2008 02:56:20 -0700, EngelseBoer
wrote:

is it possible to search a column (A)
and copy the 1st word of each cell to (B)

A B
Dopper Zulu = Dopper
Korma Xhosa = Korma


Assuming that there is always at least one space in the cells of
column A you can try the following formula:

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

Copy down as far as needed.

Hope this helps / Lars-Ã…ke