Autoreplacing letters with numbers

Hello Alex

Thank you for your question and welcome to the forum.

I think you will be able to use Replace to do this (Edit-Replace or use Ctrl + H).

Enter the letter you want to replace next to Find what:
Enter the number you want to replace the letter with next to Replace with:

Then click Options and tick the Match entire cell contents box - this way not every instance of the letter is replaced (e.g. if the letters are part of words).

You can either use Replace All, or use Find All first so you can check that the entries that will be replaced are the ones you want to overwrite, then use Replace All afterwards.

Kind regards
Amanda