=--RIGHT(A1,LEN(A1)-2)
--
David Biddulph

"Neil Pearce" wrote in message
...
Dear all,

I have a programme that measures areas off of drawings. The recorded data
is produced in Excel cells as:

A:32.2
B:245.2
C:9.2
etc.

e.g. each cell contains 'letter+colon+number'

What formula or format would I require to drop the "letter:" thereby
isolating the numbers and enabling their manipulation?


Thanking-you in advance,

Neil