View Single Post
  #2   Report Post  
Harlan Grove
 
Posts: n/a
Default

wrote...
Is there a formula with which I can extract part of a text-string ...
After the First "." and before first "Blank Space"?

....

=MID(x,FIND(".",x)+1,FIND(" ",x&" ",FIND(".",x))-FIND(".",x))

The point of the &" " is to avoid errors when there are no spaces after the
initial period, in which case the formula above returns the entire substring
to the right of the initial period.