Aug 17 2019 12:17 PM
I need to update a spreadsheet that has copied values from Bank statements. The bank statements always include text after the amount, such as $212.89 USD or $212.89 CAD. I can easily sort the values by currency type, but i can't seem to get a macro to work that will simply erase the spaceUSD or space CAD out of the cell and leave the $212.89. It has got to be simple but I can't figure it out. Ideally the macro would clean 4 to six rows at a time, for example...
From To
$212.89 UDS $212.89
$143.24 USD $143.25
$89.00 UDS $89.00
$961.23 USD $961.23
Can someone help?
Aug 17 2019 01:05 PM
HI @K_DeMaere
In case bank uses the same format then your requirement can simply be achieved using below formula (no need for macro):
=LEFT(A1,(LEN(A1)-4))
A sample file is also attached for your reference.
Please let me know if it works for you.
Tauqeer
Aug 18 2019 05:57 AM
You may Ctrl+H and Replace All " USD" (type without apostrophes) on nothing - for entire worksheet or selected range