Forum Discussion
Solved
Sum number contain letter
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 |
- 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)
4 Replies
- 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)- 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! 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))
=IF(ISBLANK(A1), "", LEFT(A1,1) & (VALUE(MID(A1,2,LEN(A1)-1)) + B1))
