Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Hello Everyone
An u please suggest a formula to solve this problem post code Suburb formula Result required 4034 Aspley post code Suburbs 4034 Geebung 4034 Aspley, Geebung, Zillmere 4034 Zilllmere 4035 Beachmere, Cannonhill 4035 Beachmere 4035 Cannonhill so forth Document contains list of postcodes & suburbs Can u please suggest a formula to concatenate the above Thanks varun |
#2
![]() |
|||
|
|||
![]()
Can anyone please help with this problem..need a formula
thanks varun "varun" wrote: Hello Everyone An u please suggest a formula to solve this problem post code Suburb formula Result required 4034 Aspley post code Suburbs 4034 Geebung 4034 Aspley, Geebung, Zillmere 4034 Zilllmere 4035 Beachmere, Cannonhill 4035 Beachmere 4035 Cannonhill so forth Document contains list of postcodes & suburbs Can u please suggest a formula to concatenate the above Thanks varun |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
post code on col1 & list of suburbs in col2 - what is the formula | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Code Post: Extract Trendline coefficients | Excel Discussion (Misc queries) |