| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Merge text list
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? |
|
#2
|
|||
|
|||
|
Use the ampersand '&' to combine text or the Concantenate function.
=+Sheet1!A1&Sheet2!A1&Sheet3!A1&Sheet4!A1&Sheet5!A 1&Sheet6!A1&Sheet7!A1 HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Rosie" wrote: 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? |
|
#3
|
|||
|
|||
|
Maybe I did not explain enough.... Each of the worksheets have three columns
and multiple rows. I do appreciate your assistance. "Gary L Brown" wrote: Use the ampersand '&' to combine text or the Concantenate function. =+Sheet1!A1&Sheet2!A1&Sheet3!A1&Sheet4!A1&Sheet5!A 1&Sheet6!A1&Sheet7!A1 HTH, -- Gary Brown If this post was helpful, please click the ''''Yes'''' button next to ''''Was this Post Helpfull to you?". "Rosie" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop through email address list to send e-mails | Excel Discussion (Misc queries) | |||
| How do I create a bulleted list text format inside cell? | Excel Discussion (Misc queries) | |||
| List box not being displayed in second worksheet | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Hybrid Mode
