| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA Macro - parse data
Hello
I need help on very simple Excel question. I have excel file exported from quickbooks which has buying cos column: Here is some sample data $0.04 $1.50 $1.135 $0.445*04 $0.01*EX $0.02(some text) $0.063 ES I want to get only cost ( means I want to delete the strings after "*", "(" , or space ). Thank you in advance for your help!!! Jaso -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parse row data in Excel | Excel Discussion (Misc queries) | |||
| How to parse data | Excel Discussion (Misc queries) | |||
| How to parse data | Excel Discussion (Misc queries) | |||
| Parse raw data | Excel Programming | |||
| REQ: Simplest way to parse (read) HTML formatted data in via Excel VBA (or VB6) | Excel Programming | |||
Threaded Mode
