Add the numbers only in a cell

[jimblimm]

in a1 i have
ns24

in this particular cell im looking for a formula that will add the last 2 numbers together
2+4

but if the cell has on one numerical value such as

ns4

the value should return only the one numerical digit
4

 

[barry houdini]

Will the cell always contain 2 letters then a number, how many digits might there be?

 

[jimblimm]

two letters, in front
ns

1 or 2 digits at end
ns21

or ns1

it wont exceed 2 digits

 

[barry houdini]

OK, try this formula

=MID(A1,3,1)+(0&MID(A1,4,1))

 

[hurgadion]

Hi,
try the formula:

=IF(LEN(A1)=4,RIGHT(A1,1)+MID(A1,3,1),RIGHT(A1))

Best regards.

 

[jimblimm]

WORKS PERFECT! Thankx!!!