Excel formatting
 

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

Excel formatting
 

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

"Neil Pearce" wrote:

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

Excel formatting
 

=--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