View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] edbarbie@gmail.com is offline
external usenet poster
 
Posts: 2
Default 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