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
|