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?
D - is there a logic that could be used to split the text?
For example, it is easy to separate the Postcode and the Country. But for the rest, there needs to be some sort of logic like number of words, or a special separating symbol - an extra space, a comma, etc - between the address segments.
Cheers
<-- If you're happy & you know it...click the star.:-)
Yes, but I'm unable to find out the solution for this, I try Text to coloumn but the all address are different so not in use properly so please suggest.
Thanks
Anyone help me.......
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks