Re: Sort Text and Numbers:
Well, it's the same problem as the precedent macros. Civic numbers belong to their respective street and those streets to their repective sectors. So sectors are sorted. Then among a specific sector (for each sector) streets belonging to this sector are sorted inside that sector, and the same things apply to civic numbers sorted inside their specific street. It's exactly the same principle we've done previously. In fact, the last macro you've written does exactly what I just described. The only problem is that the first column is not numbers to be sorted but names in letters. It's only a matter of changing the type of characters to be sorted in the first column in this last macro.