| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I combine cell contents?
Good afternoon. I know you can either use the concatenate function or the
formula =A1&B1 to combine cell contents. However, if I am combining contents from 100 different cells, individually selecting the cells become more cumbersome. Is there a way to short cut this formula to pick up a range of cells I need to combine the contents for?-- kind of how the reverse function of it works for Text to Columns? Thank you very much, Storm |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I combine cell contents?
See one response at your other post.
Gord Dibben MS Excel MVP On Fri, 13 Apr 2007 14:38:02 -0700, Storm wrote: Good afternoon. I know you can either use the concatenate function or the formula =A1&B1 to combine cell contents. However, if I am combining contents from 100 different cells, individually selecting the cells become more cumbersome. Is there a way to short cut this formula to pick up a range of cells I need to combine the contents for?-- kind of how the reverse function of it works for Text to Columns? Thank you very much, Storm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I am trying to combine contents from 2 cells into 1 | Excel Worksheet Functions | |||
| Combining cell contents when there is content to combine | Excel Discussion (Misc queries) | |||
| How do I combine the contents of multiple cells in one cell? | Excel Worksheet Functions | |||
| Combine contents of multiple workbooks into one worksheet | Excel Worksheet Functions | |||
| Combine the contents of two cells. | New Users to Excel | |||
Linear Mode
