Addition Error
 

If i type to A1, "r"(not quote) and B1 "1"(not quote), and C1 "=A1+B1"(not
quote), i'm taking an #Value error... How can i solve this issue?

Addition Error
 

=SUM(A1:B1)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"metude" wrote:

If i type to A1, "r"(not quote) and B1 "1"(not quote), and C1 "=A1+B1"(not
quote), i'm taking an #Value error... How can i solve this issue?

Addition Error
 

Which result are you trying to achieve?

If you want a result of:-

r1

- then uses the following formula in cell C 1:-

=CONCATENATE(A1,B1)

Please hit yes if my comments have helped.

Thanks.

"metude" wrote:

If i type to A1, "r"(not quote) and B1 "1"(not quote), and C1 "=A1+B1"(not
quote), i'm taking an #Value error... How can i solve this issue?

Addition Error
 

If you want to concatenate, not add, it's =A1&B1
--
David Biddulph

"metude" wrote in message
...
If i type to A1, "r"(not quote) and B1 "1"(not quote), and C1 "=A1+B1"(not
quote), i'm taking an #Value error... How can i solve this issue?