Separating Data



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


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question