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