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?