I have a dilemma I am hoping someone might be able to help me with! I have exported a PDF file into excel that has a lot of information that populates into one cell. I need to split this information into separate cells, but all the information has different spacing. Here is an example:
John Smith 1234 Main St Charlie Motto 6548 Teflon Ave Shannon Guesswho 12W546 Spoon Dr
So, I need to put the names in one cell and the addresses (Preferably numeric and street separate).
Is there any way to do this?