Extract Part of String

  • Thread starter Thread starter SIGE_GOEVAERTS
  • Start date Start date
S

SIGE_GOEVAERTS

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
 
Is there a formula with which I can extract part of a text-string ...
After the First "." and before first "Blank Space"?
Click to expand...
....

=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.
 
Back
Top