I received a download of 10K company names, contact person, addresses and phone numbers. They were given to me all in column A. Is there a way to move the addresses and phone numbers below the company name to different columns (address 1, address 2, city, state, zip, phone number) so that I can filter. Some addresses are one line and some are two lines. Sometimes there is a name, sometimes there is no name. I feel there is a quicker way to do this other than copy and paste. Thanks.
The word "Company" is not in each company name. But the company name is bolded. There is a company name for each entry. And then additional details in the next 3 - 5 lines. Does that answer your question? Thank you for responding! I am hoping to save someone a lot of copying and pasting!