Automatic convert of initials to Full name

Hello everyone,
I hope you're all well. I have a simple Excel task I'd like help with through vba.

I want any initials I write in column A to automatically convert to the corresponding names in column D.

Importantly, the names populated in column A should not change, even if the content in columns C or D is deleted.

The list in columns C and D only goes up to row 100.

If the initials written in column A are not found in column C, I would like the cell in column A to display "not found."

Thank you for your assistance.

Hi there,

Take a look at the attached version of your workbook and see if it does what you need. It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

When working with both Greg and John, all codes operate absolutely fine. However, I've noticed that when Excel suggests a predictive full name and I press Enter, it returns 'not found,' even though I intended to select that predictive name. In essence, I want the code also to recognize the predictive name when I press Enter for it, considering it as true in such cases. So if i start to type "at" and predictive text pop up to be "Ahmad tarraf", then I may automatically click enter to return "Ahmad tarraf", and not to be bounded by inserting only initials in that case. Thanks a lot

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

Glad I was able to help.

Best regards,

Greg M