View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default A + sign between two cells in a maths workbook

Hi!

Try this:

=A1&"+"&B1

Or, if you want a space before and after:

=A1&" + "&B1

Biff

"Cheriyan" wrote in message
...
A + sign between two cells results in a Mathematical function. how to
avoid
that?