I need help in extracting and formatting a column that contains text. The output needs to be:
RGXXXXXX (RG followed by a 6 digit number).
The data is stored in various flavors. I have attached a list on some of the variants. So in the example below:
The output should be RG277803 after running some public function that I can call in a MS Access query. I am new to this and could really use some expert help.