hi sharon

Sorry if I misunderstood something,

assuming yuo have the text between a2 and a20

=A2&A3&A4&A5&A6&A7...etc

hth
regards from Brazil
Marcelo

"SharonGaila" escreveu:

I have a continous column of cells with text in them. I want to consolidate
all of the information in those cells into one cell in another worksheet.
Any suggestions as to how I can accomplish this? FYI: copy and paste link
does not work.