Trying to create a simple macro in Excel

[K_DeMaere]

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?

[#2]

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

[#3]

@K_DeMaere 

You may Ctrl+H and Replace All " USD" (type without apostrophes) on nothing - for entire worksheet or selected range