Address Sorting - using Excel Programming / VBA / Macros

[Dnyan]

I have a data file in which address is given and everyday I have to sort this data as per below:

Flat/Premise No, Building No, Building Name, Street Name, District Town, County, Country, Postcode like this.

I have to sort every day thousands of data, so is it possible to use any Shortcut/ Formula or Macro and sort all address as per above mentioned?

The attachment is given in below link
Address Sorting - using Excel Programming / VBA / Macros​

 

[oldbrewer]

not clear what you want - if original data is as above, how do you want to sort it

you can sort by eg postcode then county then town

 

[hiker95]

Dnyan,

A message to forum cross posters, please read the following link:
Excelguru Help Site - A message to forum cross posters

 

[Dnyan]

Dnyan,

A message to forum cross posters, please read the following link:
Excelguru Help Site - A message to forum cross posters

Thank you very much for this, but now please tell me how can edit this post for make correction?

 

[Dnyan]

not clear what you want - if original data is as above, how do you want to sort it

you can sort by eg postcode then county then town

Hi

Want to sort all address as per given tabs in excel.
I used Text to column but every time address are different so not possible so please help me for the same

 

[oldbrewer]

Flat/Premise No, Building No, Building Name, Street Name, District Town, County, Country, Postcode like this.

the above is what you have - how do you want to sort it? Spell it out for us (I personally do not download links etc)

 

[Dnyan]

Flat/Premise No, Building No, Building Name, Street Name, District Town, County, Country, Postcode like this.

the above is what you have - how do you want to sort it? Spell it out for us (I personally do not download links etc)

Manchester Road East Sussex United Kingdom AB12A 2SL

Bell Farm Lane Chesire United Kingdom BP14 5ZA

ABC Road Gydaad United Kingdom AK87 9SU

Engineers Road Middleast United Kingdom PS5 8EA

<colgroup><col></colgroup><tbody>
</tbody>

Want to sort above address as per below tabs
Flat/Premise No	Building No	Building Name	Street Name	District	Town	County	Country	Postcode
Lower Ground, 1st, 2nd, 3rd Floors	1		XYZ Street		London		United Kingdom	PE9A 8ZP

<colgroup><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[oldbrewer]

as some addresses will have building number, and some building name, and some neither of these, and some both of these, and "streets" can also be called road, lane, close, avenue, etc, you cannot do this. Only your brain can do this degree of sorting. Text can be broken up by detecting words, spaces, commas etc but if one address is 4 ABC Road, another is ABC Road, another is Appartment 2, 4 ABC Road, excel cannot be used.