Shift Cells at a time
Posted by Deepika on April 25, 2000 4:29 AM
I have a address list of 100 people one below the other. For example, it is like this:
# 56, Haines Road,
Suite 67, San Jose
CA - 98123
(989) 234 2463
Now, my problem is that i have to arranage this information row by row. ie. in A1 I must get Deepika, B1 i must get # 56, Haines Road, C1 CA - 98123 and D1 i must get (989) 234 2463.
Kindly help me with this as soon as possible.