Replacing cells that have 2-3 letters

[drewd]

What I need to replace the cells that have 2-3 letters is:
"Not A Defect Code!!!"
I have a sheet that has many different defect codes such as:
MC
WP
MPI,ect,ect
All of these will be change to the defect code they represent.
I could not figure out how to change a defect code that was improperl
entered in such as:
"FC": to "Not A Defect Code!!!"

thank you for the help
Dre

 

[Myrna Larson]

Assuming there are no single letters, in another column, say G1

=IF(LEN(A1)<42,"Not a Defect Code!!!",A1)

Copy this down as far as needed. Then Edit/Copy the column of formulas, select
the column with the erroneous codes and Edit/Paste Special and select the
Values option.

 

[Myrna Larson]

Typo there: should be 4, not 42.