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.
|