Doesn't the original column still have the numbers in front? Show that column,
but sort by the other column and hide it when not needed.

Barto9729 wrote:
Great this works! Is there a way to put the numbers back in front now that i
have sorted them (without reordering or course)?

"Glenn" wrote:

Barto9729 wrote:
I have a list with a column of street addresses. I would like to sort by
street but ignore the house number.

for example is want the results to be:

123 Pine
456 Pine
145 Ross
668 Ross

NOT:

123 Pine
145 Ross
456 Pine
668 Ross

Any ideas?

Assuming all of your addresses are in this exact format (might be a poor
assumption), and that you would like a secondary sort by house number (rather
than completely ignoring it), add this in another column and sort by the result:

=TRIM(MID(A1,FIND(" ",A1)+1,LEN(A1))&" "&LEFT(A1,FIND(" ",A1)-1))