ExcelBanter - Merge two cells together

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Merge two cells together (https://www.excelbanter.com/excel-discussion-misc-queries/160466-merge-two-cells-together.html)

slavenp

Merge two cells together

How would I do the following:

I have text in column A and text in column B and would like to merge text in
A & B into column C.

Thanks.

Gary''s Student

Merge two cells together

In C1 enter:

=A! & B1
--
Gary''s Student - gsnu200748

"slavenp" wrote:

How would I do the following:

I have text in column A and text in column B and would like to merge text in
A & B into column C.

Thanks.

slavenp

Merge two cells together

Gary, I pressed the wrong button. Your formula worked a treat. Thanks.

"Gary''s Student" wrote:

In C1 enter:

=A! & B1
--
Gary''s Student - gsnu200748

"slavenp" wrote:

How would I do the following:

I have text in column A and text in column B and would like to merge text in
A & B into column C.

Thanks.

All times are GMT +1. The time now is 07:15 AM.