Not to complicate things, but I'd also like to separate the street number from the street name which are now in a single field. Is there a shortcut or macro to find the "streetname" and have it and the rest of that cell move to a new cell?

A1 123 Main Street

desired result
A1 123
B1 Main Street

I have a list of all the street names that appear in my worksheet so I can use "find" to locate them, but I don't know the fastest way to complete the process.