Excel formatting

[Guest]

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

 

[Guest]

One way is to use a helper column and the formula

=MID(A1,3,999)

Assumes you never have more than 999 numbers you actually want.

Mike

 

[David Biddulph]

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