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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"pep2tize" wrote in
message ...

Need help
From an address column, I need to remove street numbers and move left
corresponding street name only.
thnks
Paul P


--
pep2tize
------------------------------------------------------------------------
pep2tize's Profile:
http://www.excelforum.com/member.php...o&userid=30148
View this thread: http://www.excelforum.com/showthread...hreadid=498331