Hello folks,
Bit of a strange one - I am working on correcting data inconsistencies in model numbers sent by an incorigible supplier.
The goal is finding the following string within a cell and appending the letter X at the end:
(letter)(4 consecutive numbers)(letter in defined list - [E,V]) ->...