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
|