return 1st word in string

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
 
S

Sheeloo

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))
 
L

Lars-Åke Aspelin

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
 
E

EngelseBoer

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...
 
E

EngelseBoer

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
IPhone sound quality gets worse each generation 5
numbers within numbers 9
Formula IF 1
how do you interleave two columns 4
Set chart series endpoint dynamically 0
Lock Part of a Formula 2
Can a Dropdown list change neighoring cells base of what is select 1

Top