A formula that displays the last letter in a text

[MichaelRLanier]

Is there a formula that will display the last letter in a text? I use
MID and LEN often enough, but I am unaware how either approach can be
made to display the last letter of text that varies in length.
Thanks.

Michael

 

[Pete_UK]

Two other functions to be aware of, then - LEFT(.. , ..) and RIGHT(.. , ..)

Takes the leftmost or rightmost characters from a string.

Hope this helps.

Pete

 

[RagDyeR]

Try:

=Right(A1)
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Is there a formula that will display the last letter in a text? I use
MID and LEN often enough, but I am unaware how either approach can be
made to display the last letter of text that varies in length.
Thanks.

Michael

 

[ShaneDevenshire]

Hi,

The default second arguments for both LEFT and RIGHT are 1 so if you only
want the last character you can =RIGHT(A1) or for the first character
=LEFT(A1)
The third function of this series is MID, all three of its arguments are
required.

So it would have been possible, though rather overkill to have written
=MID(A1,LEN(A1),1)