Remove all periods from the end of a text string within a cell

[GaryG9595]

Hello,
I have a column of data containing part numbers.
ex.
abc-123.
abc-12.0632.
abcdef-12.987.6540.......
grt-65498...

Is there a way that I can remove all periods from a text string in excel, but only at the end of the string?

Results needed.
abc-123
abc-12.0632
abcdef-12.987.6540
grt-65498

Thanks in advance.
Gary

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[GaryG9595]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Updated and Thank you.
I'm using Microsoft 365 apps

 

[Fluff]

Thanks for that.
How about

Fluff.xlsm
	A	B
1	abc-123.	abc-123
2	abc-12.0632.	abc-12.0632
3	abcdef-12.987.6540.......	abcdef-12.987.6540
4	grt-65498...	grt-65498
Sheet6

Cell Formulas
Range	Formula
B1:B4	B1	=TEXTJOIN(".",,TEXTSPLIT(A1,"."))

 

[GaryG9595]

Thanks for that.
How about

Fluff.xlsm
	A	B
1	abc-123.	abc-123
2	abc-12.0632.	abc-12.0632
3	abcdef-12.987.6540.......	abcdef-12.987.6540
4	grt-65498...	grt-65498
Sheet6

Cell Formulas
Range	Formula
B1:B4	B1	=TEXTJOIN(".",,TEXTSPLIT(A1,"."))

This seems to work perfectly, except it doesn't work for this one. grt-65.498... returns the same data.?
It cleaned up the others perfectly, but this one.

 

[JEC]

That one should work too though, you probably have a space behind it

 

[Fluff]

You probably have a ellipsis rather than 3 . so try

=TEXTJOIN(".",,TEXTSPLIT(A1,".",CHAR(133),1,,""))

 

[GaryG9595]

You probably have a ellipsis rather than 3 . so try

=TEXTJOIN(".",,TEXTSPLIT(A1,".",CHAR(133),1,,""))

That did it. Thank you very much sir.
Gary

 

[Fluff]

You're welcome & thanks for the feedback.