Formula help

[SlicK the original]

I receive 3 excel sheets each week with a list of cars on them.
The data has to be merged into one document.
The data then needs to be then sorted into car manufacturer, then models,
then price(descending).
I can do the first two using DATA/SORT, but it will not work when I try to
do the third(which is price)

2002 02 Fiat Punto Active 5dr Met Steel Grey £4995
2003 53 Alfa Romeo 147 1.6 TS Lusso 3dr Met Gabianno £11995
2003 53 Ford Mondeo Zetec 1.8 3dr Metallic Black £5995

Any help would be appreciated.
I can email the before and after excel file if you wish.

SlicK

 

[Max]

The figures in the price col (4995,11995,5995) could be text

Assuming the price figs are in col D, D2 downwards

In an adjacent col, say col E

put in E2: = VALUE(D2)
(this will convert the text in col D to numbers)

Copy E2 down col E

Then use col E as the 3rd sort col
[as proxy for col D]