Trimming numbers from street addresses

[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.

 

[Don Guillett]

A Formula solution would be to use a combination of FIND, MID, & LEN
=MID(L2,FIND(" ",L2),LEN(L2))

 

[George M. Fodor]

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.
--

 

[Don Guillett]

Glad to help