| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combining multiple columns using ", " seperations..
I apologize if this is a repeat.
I am trying to combine multiple columns with names in each into one column with ", " separating the values. Issue being blank cells still returning ", " between info i.e. - Jonathan, Douglas, David, , , , Joseph, , , , , , Samantha Nicole, Mathew Robert, , , , , , , , , , , Paige, Payton, , , , , Naturally I'd like to get rid of the extra comma's and spaces. Thoughts? Formula currently used: =I2&", "&J2&", "&K2&", "&L2&", "&M2&", "&N2&", "&O2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining "IF"statement with "Vlookup" | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| the "0" number is lost when combining multiple columns | Excel Worksheet Functions | |||
| Make pivot table with multiple "data" fields in columns not rows? | Excel Discussion (Misc queries) | |||
| Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
Threaded Mode
