On Tue, 1 Sep 2009 09:29:01 -0700, Sean Timmons
wrote:

Well, that's even easier than a macro... And if needed, assuming the below
lookup formula is in A2:

=right(A1,len(a1)-len(A2)) will get you the street name in A3

With this method, it would be prudent to add some error-checking to ensure the
string starts with a number. There are plenty of addresses around here that
consist just of a street name.
--ron