How can I sort in excel an address by street?? When I sort in excel the addresses column it sorts it by street number only (ex. 111 Bedford will be before 4705 Allen Street).
Maybe I need to split up the street number from the street in a separate column, but how do I extract the numbers?? (Maybe I have to use the ‘find’ and ‘mid’ function or the 'Sort' and ‘mid’ function , but how exactly is it done?)
Maybe I need to split up the street number from the street in a separate column, but how do I extract the numbers?? (Maybe I have to use the ‘find’ and ‘mid’ function or the 'Sort' and ‘mid’ function , but how exactly is it done?)