| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging columns and adding separators
Thanks Tom
-----Original Message----- =Trim(Substitute(A1 & ", " & C1 & ", " & D1 & ", " & E1 & ", " & F1 & ", " & G1 & ", " & B1,char(160)," ")) -- Regards, Tom Ogilvy "Pete" wrote in message ... Thanks that has worked great is there a way to ensure all spaces other than 1 following a comma should be ommited as I have great big spaces in the address now! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merging and adding cells | Excel Discussion (Misc queries) | |||
| MERGING COLUMNS TO ONE | Excel Discussion (Misc queries) | |||
| merging 2 cells and adding a space. | Excel Discussion (Misc queries) | |||
| Merging or Adding two .csv files | Excel Programming | |||
| Merging or Adding two .csv files | Excel Programming | |||
Hybrid Mode
