Hi!

Don't'cha love this! <g

I'm assuming that there's a space after the numbers? If not this won't work!

Try this array formula:

A1 = John Smith 1234 South St.

=MID(A1,FIND("
",A1,MATCH(1,(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1 ))),1))47)*(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1) )),1))<58),0))+1,255)

Returns: South St.

Biff

"gbeard" wrote in message
. com...
Biff,
Can I get everything right of the numbers by substituting RIGHT for LEFT?
Or is there a different way to do that?

--
Gary Beard