Merge text list

R

Rosie

I have a spreadsheet with 7 worksheets. I am trying to include a 8th
worksheet with the text from the first 7 worksheets. They all have the same
layout. Can anyone point me in the right direction?
 
G

Gary L Brown

Use the ampersand '&' to combine text or the Concantenate function.
=+Sheet1!A1&Sheet2!A1&Sheet3!A1&Sheet4!A1&Sheet5!A1&Sheet6!A1&Sheet7!A1
HTH,
 
R

Rosie

Maybe I did not explain enough.... Each of the worksheets have three columns
and multiple rows. I do appreciate your assistance.
 
Top