| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking the value of the end of a string
Hi I have a string in a column and the last two digits are going to decide
which value is going to appear in another cell. EG - YTR567TT YTR567VT YTR567CT Because the first ends in T* I want to call this a 1, the second is V* and this will be 2 and the last is C* and this should be 3. How do I conditionally fill the cell with 1, 2 or 3? I want to make it so it is carried on as a trend down the page too. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking cells for part of a text string | Excel Worksheet Functions | |||
| checking for a particular string in a cell | Excel Worksheet Functions | |||
| checking for a string & No. | Excel Worksheet Functions | |||
| Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
| Checking for the existence of a characted in a string | Excel Discussion (Misc queries) | |||
![Rob H[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
