Checking if Field Value Ends in Letter

[workinghardly]

Hi,

I am trying to use a Formula to see if a field value ends in the letter 'R'. The values are varying lengths with a mix of characters (numbers and letters).  A new column will indicate if it does (R) and does not (D).

Something like this:

ANIMAL	R/D
DOG123	D
CR123AT	D
MOUSER	R
COW	D
BIR123DR	R
OCTOPUSR	R
FROX	D
S456EAL	D
PEN54GUINR	R
B23EAR	R
RFROG	D
T REX	D

Thank you.

[Claje · Accepted solution]

Hi,

Try the following formula, based on your example

IF ENDSWITH(Animal,'R') THEN 'R'
ELSE 'D'
ENDIF

[workinghardly]

Thank you very much. I did not realize there was ENDSWITH.