| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check the lasta character
Dear All
i have a range of coding where some of them are ending in letter I. There is any way to group all of them? Or is it possible to create an if function when the code in ending in I gives true and else false. Thanks in advance for your valuable time.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check the lasta character
Hi Manos
=IF(RIGHT(A1,1)="I",True,False) -- Regards Roger Govier Manos wrote: Dear All i have a range of coding where some of them are ending in letter I. There is any way to group all of them? Or is it possible to create an if function when the code in ending in I gives true and else false. Thanks in advance for your valuable time.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Check the lasta character
Maybe this
=RIGHT(A1,1)="I" -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Manos" wrote: Dear All i have a range of coding where some of them are ending in letter I. There is any way to group all of them? Or is it possible to create an if function when the code in ending in I gives true and else false. Thanks in advance for your valuable time.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check for character in string | Excel Discussion (Misc queries) | |||
| Spell check / character cell limit | Excel Discussion (Misc queries) | |||
| ü instead of a check mark when I try to copy it from Character Map | Excel Discussion (Misc queries) | |||
| formula to check Cell value within specific character | Excel Discussion (Misc queries) | |||
| check if the text string start with a specific character | New Users to Excel | |||
Linear Mode
