Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
merge text from a column into on cell seperated by comma's
I've got a range that can be of varying size, depending on the
information entered. I'm able to strip out the blank cells so that i am left with a range of cells that all have data in them. Now i want to take the entries in these cells and combine them into one cell seperated by columns. For example if i have A 1 Word 2 Some 3 14 4 Other then i want a cell to be Word, Some, 14, Other All of the examples i've found through searching don't seem to be working, any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for value of a cell when the cell answer has comma's in it | Excel Discussion (Misc queries) | |||
Import text doc to XL. Need items seperated by " " in new column | Excel Discussion (Misc queries) | |||
Exporting to text, cells with comma's are placed in quotes. -Bad | Excel Discussion (Misc queries) | |||
column values to a cell with comma seperated | Excel Worksheet Functions | |||
place text seperated by a space in a column into seperate columns | Excel Worksheet Functions |