| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete amounts
Assume that you are having the below value in A1 cell
A1 Cell 2ND ST BISTRO POMONA, CA $23.38 Put this formula in B1 cell =TRIM(LEFT(A1,SEARCH("$",A1)-1)) Change the cell reference to your desired cell, if required. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "da" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete amounts
Assuming all amounts start with a $, use the following formula:
=left(a1,find("$",a1)-1) Regards, Fred "da" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Delete amounts
And one more...
=LEFT(A10,FIND(" $",A10)) Note the space just befor the $. HTH Regards, Howard "da" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
