Merge text list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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,
 
Maybe I did not explain enough.... Each of the worksheets have three columns
and multiple rows. I do appreciate your assistance.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking and updating mulitple lists 1
Excel Highlighting duplicates 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Multi-Worksheet Sumproduct & Listing 3
Help with getting text from "Merged Cell" 6
Merging data from mulitple worksheets 4
Pulling From Multiple Sheet 0
Excel 2013 Merge Data 2

Back
Top