| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete amounts
Hi
Is there anyway I can delete amount from each row using a formula? I have over 600 transactions from which I need to delete amount. thank you 2ND ST BISTRO POMONA, CA $23.38 7-ELEVEN 33242 ROSEMEAD, CA $5.15 7-ELEVEN 33242 ROSEMEAD, CA $7.00 99-CENTS-ONLY #0107 UPLAND, CA $4.23 99-CENTS-ONLY #0107 UPLAND, CA $6.00 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding amounts | Excel Discussion (Misc queries) | |||
| Rolling Monthly Amounts to Annual Monthly Amounts | Excel Discussion (Misc queries) | |||
| 11 $ amounts, 6 of the amounts must equal $3854.12, which 6? | Excel Discussion (Misc queries) | |||
| How do I add 5 to amounts <25, 10 to amounts 25<100, etc? | Excel Worksheet Functions | |||
| SUMIF between 2 amounts, eg 51>x> -51 | Excel Worksheet Functions | |||
Threaded Mode
