MI-L extracting street name

[Alan Gunn]

Hello all, 

Someone told me how to do this once and now I can't find it anywhere.
Sorry. 

I need to pull the street name out of a column that has both the address
number and street name. Any suggestions?

Thanks

Alan