Need excel macro
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
|