B
Boop914
I have a large spreadsheet that has the full company name, address an
phone number entered in one cell, ie:
Company ABC 123 Main Street Chicago IL 55555 (815) 555-5555
I do not have access to the source of this data, so I cannot delimi
the data when I open it. Is there a way to separate the data int
different columns so the company name, street address, city, state, zi
and phone number each have their own column
phone number entered in one cell, ie:
Company ABC 123 Main Street Chicago IL 55555 (815) 555-5555
I do not have access to the source of this data, so I cannot delimi
the data when I open it. Is there a way to separate the data int
different columns so the company name, street address, city, state, zi
and phone number each have their own column