Trim Special Chars & Small Caps and Return the Big Caps and Space only

There appears to be an inconsistency here base on my interpretation of the logic:

^8[Tt][Hh][Aa][Tt]7[18]53 ?$ with results of

8THAT715,8THAT783

Here 53 is treated as [53]

To me, this does not accord wih ..

if the number is outside [], it should be treated as fixed digit

so I would have expected result to be

8THAT7153,8THAT7853

Please add a file with a good set of sample data.

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.