Hello,

I have over 10,000 entries of part numbers with variable lengths for example

(1) 000

(2)00.00

(3)00.00.00

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,