| 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 |
| 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 | |||
![drewd[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
