You're welcome Rodney, and if you're happy with that solution that Max gave
you, super-great!....if not, as with everything else in Excel, "there is
another way".

It uses Data TextToColumns Delimited hyphen as delimiter......and
conversion to Text on both columns, then using "ASAP Utilities" to strip off
all Letter-characters, then one simple formula copied down for the division
and to convert back to numbers....=IF(B10,A1/B1,A1)*1.....could probably all
be done with a macro, if you had to do it frequently

For me, it's easier.....

Vaya con Dios,
Chuck, CABGx3


"Rodney" wrote:

Thanks Domenic and CLR,
Have just downloaded the advice, have not tried it
(40,000 rows) and have to take off for football umpiring.
Shall return to report.
Assistance appreciated
Rodney


--

(Remove gum to reply)


"Rodney" wrote in message ...
|
| Here is what I hope to be a fair sample of some prices in a column,
| is anyone able to offer a formula to strip the text
| and convert to decimals please?
|
| 4-13F
| 2-5F
| 1-2F
| 8-13F
| 8-11F
| 4-5F
| 9-10F
| 1F
| 10-9F
| 5-4F
| 5-4
| 5-4F
| 11-8F
| 11-8EF
| 6-4F
| 13-8F
| 7-4F
| 7-4EF
| 7-4
| 15-8F
| 15-8
| 2F
| 10
| 250
| 300
|
|
|
|
|