| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
post code & suburb concatenate
Can you Please help
Question column1 has list of various post codes column2 has name of the suburbs eg 4006 Bowen Hills 4006 Herston 4006 Newstead 4006 Fortitude Valley 4007 Hamilton 4007 Ascot 4008 Pinkenba 4009 Eagle Farm 4010 Mayne 4010 Albion 4011 Eagle Junction 4011 Hendra 4011 Clayfield can you please help me with a formula in excel which gives the result as follow 4006 Bowen Hills, Herston ,Newstead ,Fortitude Valley 4007 Hamilton, Ascot 4008 Pinkenba 4009 Eagle Farm 4010 Mayne, Albion 4011 Eagle Junction, Hendra ,Clayfield Thank you varun |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change case...help please | Excel Worksheet Functions | |||
| Conform a total to a list of results? | Excel Discussion (Misc queries) | |||
| Macro for changing text to Proper Case | Excel Worksheet Functions | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Code Post: Extract Trendline coefficients | Excel Discussion (Misc queries) | |||
Threaded Mode
