Hello!
The characters allowed in eg. B3 are A to Z, 0 to 9 and “-” (hyphen)
Unwanted characters should just disappear.
Suppose the following text 'KR2000050-1 is in cell B3 ( " ’ " at the beginning, should be filtered out)
I hope to get a clean result in cell C3
How should the formula be written?