Macro Help Please

  • Thread starter Thread starter suestew
  • Start date Start date
S

suestew

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.
 
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
 
Back
Top