Forum Discussion
Excel formula help
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.
4 Replies
Here is a sample of what I am needing help with.
Do you have the word "Company" with each company name, or how do you know where is company name, where is person name or something else?
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!
