I need to be able to ignore the last char in a cell that contains a number
and a letter suffix like 100K, 30B, 70M, 10% (thousand, billion, million
and percent).
I have to copy and paste a lot of numbers from another sorce and they
include the suffixes with the number. Is there a way to do this?
Thanks