Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I add a comma between a range of cells?
Example: I have cells A1 through A70 with data in each cell in the following
format 123-03-123. I need a sting of text returned that will combine the cells separated by a comma. Example: 123-34-234,234-23-234,345-23-123, etc... I need to be able to copy and paste the string in to a websearch that specifies "separated by commas no spaces" I know there has to be a simple way to do that but I am a rookie in Excel :( Thanks for all your help... Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete text to right of a comma in a range of cells? | Excel Discussion (Misc queries) | |||
need to remove a comma from end of test in cells | Excel Worksheet Functions | |||
Put all cells in one cell seperated by comma | New Users to Excel | |||
Extract comma broken address to cells | Excel Discussion (Misc queries) | |||
How do i merge data in a row of cells to be comma separated in on. | Excel Discussion (Misc queries) |