Check the lasta character

's Computer Specifications

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....

's Computer Specifications

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....
>

's Computer Specifications

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....
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
check if a string contains a particular character	kalle	Microsoft Excel Programming	3	10th Jul 2009 06:06 AM
Check for character in string	dksaluki	Microsoft Excel Misc	3	11th Dec 2007 12:53 PM
check whether character is Wingdings	guenther	Microsoft Powerpoint	0	16th Nov 2006 09:33 AM
Check the first character if its not zero then insert otherwise not	Anna	Microsoft Access Forms	1	5th Sep 2006 01:44 AM
Trying to check 3rd character in string as criteria	Duane Hookom	Microsoft Access Queries	4	28th Oct 2004 10:15 PM