Singha wrote:
Could you kindly please tell how I may add number with letters.
For example 29A+30A +19A

Thank you
--
Singha

Here's a better solution that is NOT an array formula and will only add
the A's, so if the 2nd term was 30B instead of 30A it returns 48A...

=SUMPRODUCT(VALUE(LEFT(A1:A3,LEN(A1:A3)-1)),--(RIGHT(A1:A3,1)="A"))&
"A"

Ken Johnson