View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EngelseBoer EngelseBoer is offline
external usenet poster
 
Posts: 67
Default 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