ExcelBanter - Limit returned value to last digit

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Limit returned value to last digit (https://www.excelbanter.com/excel-worksheet-functions/204192-limit-returned-value-last-digit.html)

Patrick C. Simonds

Limit returned value to last digit

In cell A4 is a 4 digit number in cell A1 I want only the last number

Bob Phillips[_3_]

Limit returned value to last digit

=IF(ISNUMBER(A4),IF(LEN(A4)=4,RIGHT(A4),""),"")

--
__________________________________
HTH

Bob

"Patrick C. Simonds" wrote in message
...
In cell A4 is a 4 digit number in cell A1 I want only the last number

Sean Timmons

Limit returned value to last digit

=RIGHT(A4,1)

"Patrick C. Simonds" wrote:

In cell A4 is a 4 digit number in cell A1 I want only the last number

ShaneDevenshire

Limit returned value to last digit

Hi,

And a little shorter:

=RIGHT(A1)

1 is the default value and you don't neet to enter it.

--
Thanks,
Shane Devenshire

"Patrick C. Simonds" wrote:

In cell A4 is a 4 digit number in cell A1 I want only the last number

All times are GMT +1. The time now is 10:07 AM.