Can I sort an address like "555 Smith St" written in one cell by street and then by address number?

Question

Can I sort an address like "555 Smith St" written in all in one cell by street and then by address number? I know i can do it in separate cells and then sort by priority, but then i have trouble with my mail merge into Word.

Answer 1

Only possible if you have the street and number in separate cells. And since it caused problems with the mail merge, you'd probably have to go through the merge settings to make sure the right cells end up in the right places. It would be more work to set up the mail merge, but it doesn't sound impossible. Good luck!

Answer 2

Impossible is only limited by your own imagination ....
Independent from the programming language you wish to use, you need to tokenize the words inside each address entry resulting in:
555
Smith
St
This should be sorted into a container;
You need to determine a mechanism to consider Smith a part from St (Street) meaning that in reality the tokenizing should split the tokens into:
555
Smith St

instead of:
555
Smith
St

In OOP Design, you could create different attributes for that:
street_number
street_name

And almost in each programming language, the associative container "Set" provides a mechanism to sort ranges based on certain attributes.

Answer 3

using what language? PHP? ASP?

Answer 4

Honey child do it any way you want to ain't you doing it !Take my advice!

Answer 5

Nope, not really possible.