Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro to copy and paste values (columns)I have a macro file built | Excel Programming | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |