Extract Part of String
 

Hi There,

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

eg.
Ped.Dry BeuatifulWeather.30 =results: Dry
Ped.VeryWet HellBreak.15 = VeryWet
Ped.Dry LA.La lala = Dry
....

All help, sugestions welcome
Sige

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.