How to delete the combination of Character and number records from the field

[rkpatelqlikview]

Hi Experts,

Please suggest on the below scenario.

Please find the attached sample excel data

I tried with multiple functions to remove the records from the field.

I want to remove the codes which are combination of number and character records.

Original code size is '9'

In below example removed records from 10201130MH to NE09. Thanks in advance.

[rkpatelqlikview]

Thank you so much Marco and Peter. Both are working very well.