| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Text From Cells
If I have 100 cells that contain text and I want to write an Excel
formula that will combine all cell texts into cell without using =a1&a2&a3 what would I do? The volume of cells is too large to use the & in the formula and the transpose feature does not combine text into one cell. A1 = one A2 = two A3 = three A4 = four A5 = five I want B1 to = one two three four five |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining cells with text | Excel Worksheet Functions | |||
| Combining text cells. | Excel Discussion (Misc queries) | |||
| Combining text from different Cells IF | Excel Discussion (Misc queries) | |||
| combining text from 2 cells | Excel Discussion (Misc queries) | |||
| Combining Text and numbers from two cells | Excel Discussion (Misc queries) | |||
Threaded Mode
