To sort a row of columns: Define the following formula on a blank row: =transpose(sort(transpose(C3:H4))) Then just copy the sorted row and copy...special..values only Delete all but the copied row
To sort column of addresses that contain street numbers :
Create a blank column next to the address column. Select a blank cell adjacent to the address list, and type this formula =MID(A1,FIND(” “,A1)+1,255) (A1 is the cell of your address list), and press Enter button, then drag the fill handle to fill the range you want. After that, you can see all addresses are extracted to the help column except the street numbers.