Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi -
I've got a worksheet with a column of data like this: $2,000.00 3/10/2003 $25.00 6/27/2003 $30.00 6/24/2003 $25.00 6/30/2003 $50.00 7/8/2003 etc. I need to separate out the dollar amount from the date - put them each in their own cell/column. I figured a way to do this would be to write a script that looks for a /, then cuts everything two charactes to the left and pastes it in a new cell/column. Is this possible? I'm not sure how to write it...and maybe there's an easier way? Thanks, E |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming |