Replacing cells that have 2-3 letters
 

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

--
drew
-----------------------------------------------------------------------
drewd's Profile: http://www.excelforum.com/member.php...fo&userid=1474
View this thread: http://www.excelforum.com/showthread.php?threadid=26369

Replacing cells that have 2-3 letters
 

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.


On Sun, 26 Sep 2004 22:08:32 -0500, drewd
wrote:


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 improperly
entered in such as:
"FC": to "Not A Defect Code!!!"

thank you for the help
Drew

Replacing cells that have 2-3 letters
 

Typo the should be 4, not 42.

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