We have cells with for example the following info...

A-10A SUPER DETAIL SETS - 1:48 Scale - 26001
'69 Camaro Z\28 2 in 1 - 1/25 - 85-2148

What were trying to do is to clean up the data and gain the scale info from each cell so for example

A-10A SUPER DETAIL SETS - 1:48 Scale - 26001 we would have a result of 1:48
'69 Camaro Z\28 2 in 1 - 1/25 - 85-2148 we would have a result of 1/25

The scale info could reside anywhere in the cell no set position and not always with the text scale in it the common elements I suppose will always be a 1: or a 1/ then obtaining the following set of no's till you hit a space would return the scale value.