How do I split the columns in Excel?

Question

I have 10,000 addresses in a single column... How do I split it into 3 columns?? Kindly help me... Its urgent...

Answer 1

Select the whole column and click on Data, Text to Columns



There's short wizard (2 slides)



1) Select delimited and

2) specify the delimiters (the characters, usually commas, that separate the items of data.



Good luck

Answer 2

if you mean 3 columns of equal row length from a single column with 10,000 rows, that is a macro.



If you mean column 1 has 3 fields and you want the 3 fields as 3 columns of 10,000 rows, that is an Excel function. Right-mouse-click -->split, follow the wizzard prompt.



link below for a macro example.

Answer 3

Can you provide a little more information. Were the addresses imported from a data base - do you still have the original database with the addresses. Please state what package the addresses are in - were they in Access or are they just from a table in a Word document?



The addresses in Excel - how do they look in the cell - separated by commas or ????