Macro Help Please
 

I have a spreadsheet consisting of one column. Each row begins with a date
and is followed by a description:

7/14/94 Information 1-3,
7/19/94 Transportation Request 4,
7/27/94 Summons and Return of Service 5-7,
7/27/94 Minute Entry 8-13,
8/3/94 Transportation Request 14,

I need to take all the data in each row that comes after the date and move
it to a column to the right.

Macro Help Please
 

You don't need a macro; you can do it with formulas:
In the column to the right (say B2), enter
=LEFT(A2,FIND(" ",A2)-1) and fill down
in C2, enter:
=MID(A2,FIND(" ",A2)+1,255) and fill down.
Then select B2:C100 (or as far as necessary), Edit/Copy, Edit/Paste Special
and click Values.
Finally, Delete the stuff in column A, shifting cells Left (or Copy what you
just pasted, and paste again onto A2).

HTH

"suestew" wrote in message
...
I have a spreadsheet consisting of one column. Each row begins with a date
and is followed by a description:

7/14/94 Information 1-3,
7/19/94 Transportation Request 4,
7/27/94 Summons and Return of Service 5-7,
7/27/94 Minute Entry 8-13,
8/3/94 Transportation Request 14,

I need to take all the data in each row that comes after the date and move
it to a column to the right.