ExcelBanter - A + sign between two cells in a maths workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - A + sign between two cells in a maths workbook (https://www.excelbanter.com/excel-worksheet-functions/71112-sign-between-two-cells-maths-workbook.html)

Cheriyan

A + sign between two cells in a maths workbook

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

Biff

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?

All times are GMT +1. The time now is 10:25 AM.