In Excel, using VBA/Macro, how do I extract last four letters of a ten letter string?
===

For example, if I have

ABS YUR YUAO 

HFH IWO OQNX

YQO PQM QUCC

How do I extract the last four letters in another column by using a macro? It would be good if I could record a macro for the first string, and then drag that result down to get the other four letters of the other strings. I should also be able to do this for new string. For example, if I write a new string that states

OWQ UEU QOSN

Then I should be able to get QOSN as a result by simple running the macro. I would assume the code would read: extract last four letters of such and such cell. Please let me know if you need any clarifications. How can I do this? Thank you.