Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
CONCATENATE on separated values
I would like to know how I can take different cells (non concurrent)
and string them together in another cell with separators. The CONCATENATE function can't do this. The end result that I am looking for is to select a number of cells using a userform and listbox with checkboxes, and have all of those values combine and be pasted into a cell of my choosing. I have the userform, the listbox, and the checkboxes (courtesy of John Walkenbach's book), I need to figure out how to combine my selections into a single cell. Thanks for your reponses in advance. Shane |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to I create a comma separated values file | Excel Discussion (Misc queries) | |||
How do I convert a column of numbers into comma separated values . | Excel Worksheet Functions | |||
How to get values separated with / | Excel Discussion (Misc queries) | |||
Fixing Comma Separated Values (.csv) | Excel Discussion (Misc queries) | |||
Concatenate columns, separated by double quotes | Excel Worksheet Functions |