A + sign between two cells results in a Mathematical function. how to avoid that?
C Cheriyan Feb 12, 2006 #1 A + sign between two cells results in a Mathematical function. how to avoid that?
B Biff Feb 12, 2006 #2 Hi! Try this: =A1&"+"&B1 Or, if you want a space before and after: =A1&" + "&B1 Biff