VBA macro for removing entire alphabet some special characters

[BobMaccaroni]

I have a long list of strings in a1 but I want to extract the numbers from the strings. Additionally some of the strings have special character aside from just the alphabet that I also want to remove. Is there a macro that exists that will delete the entire uppercase and lowercase alphabet from each value in column A along with the special characters:
[
]
,
'
-
_
‘
.
!

TLDR: macro that converts "[S14E1007] How to tie a tie .mkv " into "1007 " with 1007 being outputted in column B while [S14E1007] How to tie a tie .mkv is inputted in column A.

 

[BobMaccaroni]

update: just chat gpt-ed this and its answer worked