ExcelBanter - Combining text cells.

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

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

- - Combining text cells. (https://www.excelbanter.com/excel-discussion-misc-queries/137878-combining-text-cells.html)

johnnyz197034

Combining text cells.

Can anyone tell me how to combine a group of text cells into one cell for the
purpose of referencing them in a formula later?
Any help is greatly appreciated!

Mike

Combining text cells.

Try this
Put your first name in A1 and your last name in B1
=CONCATENATE(A1,B1)
This one will add a comma between cells
=CONCATENATE(A1,",",B1)
"johnnyz197034" wrote:

Can anyone tell me how to combine a group of text cells into one cell for the
purpose of referencing them in a formula later?
Any help is greatly appreciated!

JE McGimpsey

Combining text cells.

One way:

=A1 & A2 & A3

If you want to do it without formulae, take a look he

http://www.mcgimpsey.com/excel/subs/mergedata.html

In article ,
johnnyz197034 wrote:

Can anyone tell me how to combine a group of text cells into one cell for the
purpose of referencing them in a formula later?

All times are GMT +1. The time now is 04:21 AM.