Seperate the data in one cell to another cell

jaynedeans

New Member
Joined
Oct 13, 2002
Messages
3
I am importing data from a database and it comes out with the following information, Example: Company Name:Address:Phone:Zip Code. The problem is that all of this data is put into one cell (A1). Is there a macro that can separate these fields? For example, column A1 will have the Company Name, column A2 will have the Address, column A3 will have the Phone etc. In other words, is it possible to have a macro identify a colon and move the data on the right hand side of the colon to the next column?
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

jaynedeans

New Member
Joined
Oct 13, 2002
Messages
3
Thanks for the suggestion. However, where in the menu or toolbar do I change the format?
 

jaynedeans

New Member
Joined
Oct 13, 2002
Messages
3
Thank you very much for your help Andrew!

On 2002-10-15 06:07, Andrew Poulsom wrote:
Activate a cell within your data and from the menu choose Data, Text to Columns.
 

Forum statistics

Threads
1,144,119
Messages
5,722,592
Members
422,447
Latest member
knopp

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top