Forum Discussion
Adding text to formula
Trying to create a formula to do this for example: first cell just a number, say 100, second cell a number plus text, say 2 kg would like to multiply and show "200 kg" as a result. Think need an...
Hi Alan,
You can not do math on a cell that contains text, here is what you should do to get the same result:
1- Remove the kg from the second cell, and keep the numbers only.
2- Write the formula for multiply like this =A1*B1 &" kg"
if you have 5 on cell A1, and 4 on Cell B1, then the result of this formula will be 20 kg
