I am using Excel to manage portions of a name
and address list.

I have parsed the address field to seperate the
street number from street name.

For example, A1 contatins 123 Main Street and
I have parsed that into B1 124 and C1 Main Street.

I parsed the information so that I could sort the
list by street name, however, Excel is not allowing
me to do that.

Is it possible to sort the contents of formula fields?

Thanks.