| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
=concatenate(cell1, cell2, etc...)
"rosey1" wrote: How can I create a formula to automatically transfer text from merged cells on one worksheet to a single cell on another worksheet? This would operate like a summary sheet with the data transferred automatically. I tried the = and clicking on the merged cells but I keep getting a zero. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting line breaks into merged text cells. | Excel Discussion (Misc queries) | |||
| requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
| Can I create a formula from text in several cells? | Excel Worksheet Functions | |||
| How can I Excel to re-size when wrapping text in merged cells | Excel Discussion (Misc queries) | |||
| How do I get merged cells to display all text. | Excel Discussion (Misc queries) | |||
Threaded Mode
