Thread: Check the lasta character
View Single Post
  #2  
Old April 19th, 2010, 09:24 AM posted to microsoft.public.excel.worksheet.functions
Roger Govier[_8_]
external usenet poster
  
Posts: 338
Default 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....