Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing cells that have 2-3 letters
Typo the should be 4, not 42.
=IF(LEN(A1)<42,"Not a Defect Code!!!",A1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing capital letters | Excel Discussion (Misc queries) | |||
Count only Letters in cells that contain both letters and numbers | Excel Worksheet Functions | |||
Replacing letters for figures in formula | Excel Discussion (Misc queries) | |||
Replacing blank cells | Excel Worksheet Functions | |||
Replacing cells that have 2-3 letters | Excel Programming |