A formula that displays the last letter in a text

  • Thread starter Thread starter MichaelRLanier
  • Start date Start date
M

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
 
Two other functions to be aware of, then - LEFT(.. , ..) and RIGHT(.. , ..)

Takes the leftmost or rightmost characters from a string.

Hope this helps.

Pete
 
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
 
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)
 
Back
Top