Need code to pull numeric data out of an alphanumeric string (string not constant)

Your profile states 2003, but your sample is 2007 or above.

This should work for either.

1/. Insert two columns after Column B "Rate"

2/. Put this formula in C2, Drag across to D2, then down as required.

Formula:

=IF(B2="","",IF(COLUMNS($C:C)=1,TRIM(MID(SUBSTITUTE(" "&TRIM($B2)," ",REPT(" ",255)),COLUMNS($C:C)*255,255)),TRIM(MID(SUBSTITUTE(" "&TRIM($B2)," ",REPT(" ",255)),COLUMNS($C:C)*255,255))*1))

3/. Copy Columns C:D and paste special > Values if required.

This trims the results and returns a number rather than a string for your rates.