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 n...
- 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)
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)
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!
=IF(F3>0,((LEFT(E3,1)&(VALUE(MID(E3,2,LEN(E3)-1))+F3))),"")
Your answer helped me a lot, thank you!