return 1st word in string

  • Thread starter Thread starter EngelseBoer
  • Start date Start date
E

EngelseBoer

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 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))
 
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
Click to expand...


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
 
thanks

Sheeloo said:
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))
Click to expand...
 
thanks

Lars-Ã…ke Aspelin said:
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
Click to expand...
 
Back
Top