I need to sort an address table alphabetically.

You can try this as a start.  If the address field was named [Address], then this will strip off the first part of the text up to the first space.  I don't know if you have a few hundred addresses or thousands, but you may need to have a Street name override field to handle cases where this formula does not work.
 
Note that if you look at the field properties for the Address field it will give you the name of the Subfields.  for example [Address: City]