Brilliant, that solves it.

Thanks for your help.

Gordon

"Max" wrote in message
...
Think we could put in B1, and copy down:
=LEFT(A1,SEARCH("£",A1)-1)+0
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Gordon Baxter" wrote in message
...
No that doesn't work Max. Perhaps I have not explained it very well.

The following are samples of figures I get: 410 £2, 60 £19, 700 £4, 29
£36.

After reducing these down to the first four digits I am left with: 410,
60
£, 700, 29 £.

I am looking to get rid of the £ sign following the 60 & 29.

Regards
Gordon