Sum number contain letter

[IlonaK2208]

Hi All, 

I'm trying to sum 2 values, first value contains letter.

Is there any way to sum this 2 values? Currently, I found 2 options to separate the number from the letter, but I need the return number will include letter: G1850388+146= G1850534.

Please advise, thanks a lot in advance!

First SN in 2023	EST # of units
G1850388	146

[#2 · Accepted solution]

Here's an example:
If the first value with the letter is in cell A1 and the second value is in cell B1.
You can use the following formula in cell C1 to achieve the desired result:
=LEFT(A1,1) & (VALUE(MID(A1,2,LEN(A1)-1)) + B1)

[#3]

@NikolinoDE 

It's work! Perfect, thank you!

Maybe you can help with removing an error when the cell is empty? 

I tried to edit formula with IF function but it didn't work

=LEFT(E3,1)&(VALUE(MID(E3,2,LEN(E3)-1))&(IF(ISBLANK(E3),"",F3+G3))

[#4]

Hi again, I found he way to avoid false values:
=IF(F3>0,((LEFT(E3,1)&(VALUE(MID(E3,2,LEN(E3)-1))+F3))),"")
Your answer helped me a lot, thank you!

[#5]

=IF(ISBLANK(A1), "", LEFT(A1,1) & (VALUE(MID(A1,2,LEN(A1)-1)) + B1))