Remove certain characters from the end of a string only

Hi,

im looking to remove symbols from the end of a string only, even if the symbol occurs in the middle of the string. i have a column full of different numbers, some cells including letters and symbols as well, and need any cell that ends with a symbol, such as a full-stop, to have the symbol deleted to just leave the number.

for example:

0054671..ljahd156. => 0054671..ljahd156
hdfiod465..... => hdfiod465
ha56756..g465 => ha56756..g465
48131532.... => 48131532

I have tried a few different "LEFT" formulas but it seems as though it needs the same amount of characters at the end of each cell to work properly and the cell content i have is not consistent like that.

Any ideas?

Thanks,

Tom

Apologies, see the below attachment for the data

Remove symbols from end of cell only example.xlsx

Cheers

the first forumla only removes 1 full-stop from the end of the string in the cell, whereas there are some cells with multiple full-stops at the end that need to be removed. but the full-stops in the middle of the strings of text need to remain so the substitute forumla is no good.

the UDF solution you have provided in the attachment works perfectly. However, how do i implement the same formula you have used into a different workbook? when i try it comes up with #NAME? in the cell.

I have no experience when it comes to UDF but am keen to use the solution you provided unless there is an easier way.

cheers

you're a genius!

works out well.

thanks heaps, much appreciated

Tom

array formula
{=SUBSTITUTE(LEFT(A2;MAX(IF(MID(A2;ROW(INDIRECT(1&":"&LEN(A2)));1)<>".";ROW(INDIRECT(1&":"&LEN(A2))))));CHAR(133);"")}

Sixthsense the formula you provided does not work, as it comes up with a blank cell.

Ghozi your formula works well. out of curiosity, how would i go about adding to the parameters to remove any symbol from the end of the string, for example if the string is "456abc../#" and i wanted it to be "456abc" what would i add to your formula to remove the "/" and "#" as well as the "."??