moving cell contents (automatically)
 

I have a spread sheet that contains one column of information. That column
contains client addresses. Each line of the address is in a seperate cell
(Name in A1, Street in A2, City,State,Zip in A3). This pattern continues
through about 1000 contacts. I need to move the contents out from a single
colum to three colums where column A would be Name, B would be Street, and C
would be City,State,Zip.

Is there a way to have excel do this automatically. Say move every 2nd cell
to colum B and every 3rd cell to column C.

By the way, I am using Office XP, but have 2003 at home if needed.

Thanks in advance.

Rusty

one method
in B1 enter =A2
in C1 enter =A3
in D1 enter =mod(Row(),3)
copy B1:D1 and paste to the bottom of the date
Select all
Copy and paste special values
and <data<Filter<Autofilter
in column D filter arrows select Custom Not equal to 1
Select all of the rows except row 1 (Because of the way that autofilter
works the top row is not filtered)
delete these rows

"Rusty" wrote:

I have a spread sheet that contains one column of information. That column
contains client addresses. Each line of the address is in a seperate cell
(Name in A1, Street in A2, City,State,Zip in A3). This pattern continues
through about 1000 contacts. I need to move the contents out from a single
colum to three colums where column A would be Name, B would be Street, and C
would be City,State,Zip.

Is there a way to have excel do this automatically. Say move every 2nd cell
to colum B and every 3rd cell to column C.

By the way, I am using Office XP, but have 2003 at home if needed.

Thanks in advance.

Rusty