How do I copy just the words in an Excel cell that contains numbe.

J

JKrohnJ

I have street address data. I want to sort based on addresses on the
streets. I think I need to somehow seperate the street number from the
street name and then sort?
 
J

Jason Morin

A1: 123 Main St.
A2: Main St.

Formula in A2:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

HTH
Jason
Atlanta, GA
 
Top