ExcelBanter - combining cells

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

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

- - combining cells (https://www.excelbanter.com/excel-worksheet-functions/64083-combining-cells.html)

Mindy

combining cells

I'm trying to combine a few cells. Say I have Mindy jo Thomas in a1, a2 and
a3. I can combine Mindy and jo by putting =A1&" "&A2 but when I try to add
Thomas like =A1&" "&A2" "&A3, it doesn't like the A2. what am I doing wrong?

David Billigmeier

combining cells

Missing an "&" sign...

=A1&" "&A2&" "&A3

--
Regards,
Dave

"Mindy" wrote:

I'm trying to combine a few cells. Say I have Mindy jo Thomas in a1, a2 and
a3. I can combine Mindy and jo by putting =A1&" "&A2 but when I try to add
Thomas like =A1&" "&A2" "&A3, it doesn't like the A2. what am I doing wrong?

All times are GMT +1. The time now is 02:54 AM.