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
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