Delete Specific Text from Column of Cells

Hi Folks

In the attached file you will see text like USD,RM,EA, etc. I need either a formula or a Macro to delete these texts from the Cells. Any ZZ+number should remain together with the number in the left. From time to time new text may be introduced to delete so I need a way to add them.

I'd appreciate your feedback.

Many thanks

Brian

I have no idea what you want - sorry. Please add your desired outcome manually to the workbook and post again.

It would appear that your data is uniform in layout, but might you have a line with 2 characters to remove (e.g. RM), and also a ZZ+number to remain? (Your sample data does not have such an example).