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

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

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,181,241
Messages
5,928,835
Members
436,632
Latest member
DrCSdeLange

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