Addition Error

[metude]

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?

 

[Luke M]

=SUM(A1:B1)

 

[trip_to_tokyo]

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.

 

[David Biddulph]

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