| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i'm missing something
im trying to simplify my personal bookkeeping. i import my data from
the bank as a .csv and want to transfer it to a second sheet without all the jibberish. its set up with a vlookup etc. but what i can't figure out is say my entry from shopping at wal-mart has POS PURCHASE - WAL-MART #0822 WAL-MART but i want to transfer it and say WAL-MART i tried if(a1="*WAL-MART*","Wal-Mart",0) as a test but i guess it didn't like the wildcards.. also what would be the best way to convert multiple entries, example if i went to home depot, not wal-mart. would using or with if be the best solution? thanks in advance, jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Who is missing ? | Excel Discussion (Misc queries) | |||
| add-ins missing | Excel Worksheet Functions | |||
| Toolbars Missing, And option to Add Missing | Excel Discussion (Misc queries) | |||
| Missing row | Excel Discussion (Misc queries) | |||
| Missing Row | Excel Worksheet Functions | |||
Threaded Mode
