Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |