Here is my situation: I have a few thousand lines of data, so I need a way to automate this or I will be here til I retire!
One of the columns has an address (123 Main St Anytown CA) which is followed by a contact person (not sure why the guy who made this put all that in one cell). All of...