Thread: Text Formating
View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default Text Formating

Yes, using a formula like this
=MID(D7,1,FIND(" ",D7,1)-1)
where D7 contains the name in question. This formula returns
everything before the first blank space in the entry- which is great
until you run into Mary Ann X, who gets converted to Mary.