Need excel macro
 

Hi Ed,

If you need to automate this, turn on the macro recorder and perform the
operation manually.

This will provide you with base code which can be edited to enable generic
application.

If you have any problem editing the resultant code, post back with details.

---
Regards,
Norman


"Norman Jones" wrote in message news:...
Hi Ed,

With the data selected, try:

Data | Text to Columns | Delimited | Next | Check 'Space' delimiter |
Next | Finish


---
Regards,
Norman



wrote in message
oups.com...
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

Need excel macro
 

Thanks for the replies. I tried the text delimiter and it seems to
work - although I'm going to try recording it so it can be performed on
a number of worksheets within a workbook. Will write back with issues.
Thanks again!