If last word is SALE write SALE otherwise blank

[makinmomb]

Say i have as follows on a1 and a2 and a3

OKAY = GEMMA SALE
OKAY = NIRO SALE
OKAY = PROJECT

I am checking discounts given of each sales around
100 rows m I want to comment on an b1 which of
these entries were SALE related

The expected result on B1 and drag down should be

SALE
SALE
BLANK CELL

[AlKey]

=IFERROR(IF(SEARCH("Sale",A1),"SALE"),"")

Row\Col	A	B
1	OKAY = GEMMA SALE	SALE
2	OKAY = NIRO SALE	SALE
3	OKAY = PROJECT

[AlanY]

you can do a wildcard search for SALE like

=SEARCH("*SALE",A1)

and use iferror to tidy it up

=IFERROR(SEARCH("*SALE",A1),"")

[krishpraj]

=IF(RIGHT(A1,4)="sale","SALE","")

[makinmomb]

Thank you ALKEY and AlanY

Works , have long data , will be handy

[makinmomb]

Krishpraj yours kicks away the iferror , small formula and sweet

Thank you

[makinmomb]

It will work as I am not looking for SALE any where but as the last word ,
I will collect the other two if the SALE comment is necessarily not last