Trimming numbers from street addresses

  • Thread starter Thread starter George M. Fodor
  • Start date Start date
G

George M. Fodor

How do I trim house numbers from street addresses when the number of
characters varies.

For example, one address might be "4 Olde Coach Road," another might be "22
Olde Coach Road" or even "138 Cyber Lane" or even "1452 Digital Drive." At
times, there is even the odd "15 L Byte Boulevard."

Ultimately, I need to sort my list by street name, and to do so, I need to
trim all the various leading "numbers."

Thanks for your help.
 
A Formula solution would be to use a combination of FIND, MID, & LEN
=MID(L2,FIND(" ",L2),LEN(L2))
 
Hello Don,

Thank you so much for your help. This gave me the street name with a leading
space, so I simply trimmed that field and got what I needed.

Again, thanks.

George M.
--
 
Back
Top