I have over 10,000 entries of part numbers with variable lengths for example
the rule I need is if the cell has a "." need to remove 2 from the right and if it has no "." need to remove 1.
Can anyone think of a formula that could do this, I have tried Left & Right Function but it only works to a certain degree.
Thanks in Advance,