Format part of an alphanumeric code

Hi Excellers!
I've got a column with the following formula: =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(100,999) that is given me an alphanumeric code for my small business database. I was wondering if there is a way to format the values in the following manner: AA999 (where the letters are bold and the numbers are not.

I need a code that's kinda complex since I'm handling a vast amount of unique objects but I'd like to be able to identify it faster when I'm done with the inventory database. Any tips are welcome.

Thanks you, hope you have a wonderful day!
Cheers

Yes please! I'm an absolute beginner with VBA though, but I'll try my best!
Thank you very much

If you want to format the cell partially, the cell must have String type data,

So, formula or pure number needs to be converted to String value.

If that is OK, it should be easy.