| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
10,000 addresses in column A; divided into 4 sections across.
I copied address off the internet. They are all isted in column A.
example: First Place Awards 1234 Fifth Avenue New York, NY 11111 How do I get row 2 to column b and row 3 to column c? What I want. A B C First Place Awards 1234 Fifth Avenue New York, NY 11111 I have 10,000 address all in this one column that I'd like to have seperated into 3 columns. I don't have the time to cut and paste. Any way I can do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort by row instead of by column? | Excel Worksheet Functions | |||
| How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
| Formula for a column | Excel Discussion (Misc queries) | |||
| How do you sort a column of email addresses by domain name in Exc. | Excel Discussion (Misc queries) | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Threaded Mode
