[SOLVED] Re: 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" <[email protected]> wrote in message news:...
> Hi Ed,
>
> With the data selected, try:
>
> Data | Text to Columns | Delimited | Next | Check 'Space' delimiter |
> Next | Finish
>
>
> ---
> Regards,
> Norman
>
>
>
> <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>
>

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!