From: metude on 26 Jan 2010 13:29 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? From: Luke M on 26 Jan 2010 13:35 =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? From: trip_to_tokyo on 26 Jan 2010 13:39 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? From: "David Biddulph" groups [at] on 26 Jan 2010 14:50 If you want to concatenate, not add, it's =A1&B1 -- David Biddulph "metude" wrote in message news:6FF1F94D-4EFE-4753-811B-E404CDEA57DE(a)microsoft.com...> 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?