How to extract last digit(s) from numbers with multiple decimal places

[Samlise]

Hi Everyone

I have reference numbers and want to extract the number or numbers after the last decimal place


So I have 1.4.5 and want to extract the last digit, (5)

But the problem I can't get around is when it goes in to the tens, so 1.4.15 and extracting the 15 but using the same formula

Any advice gratefully received

 

[FormR]

Hi, here is one option.

Book2
	A	B
1	1.4.5	5
2	1.4.15	15
3	1.4.151564	151564
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=0+(RIGHT(SUBSTITUTE(A1,".",REPT(" ",LEN(A1))),LEN(A1)))

 

[sandy666]

or maybe Power Query

raw		raw	Text After Delimiter
1.4.15		1.4.15	15
1.4.5		1.4.5	5
1.4		1.4	4

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Type = Table.TransformColumnTypes(Source,{{"raw", type text}}),
    TAD = Table.AddColumn(Type, "Text After Delimiter", each Text.AfterDelimiter([raw], ".", {0, RelativePosition.FromEnd}), type text)
in
    TAD

 

[etaf]

probably an easier way
=RIGHT(A2,(LEN(A2)-FIND("*",SUBSTITUTE(A2,".","*",LEN(A2)-LEN(SUBSTITUTE(A2,".",""))))))

 

[Samlise]

Brilliant

Thank you everyone