For the data you posted, and depending on whether you want to keep the final period, either:

=IF(ISERROR(FIND(".",A1)), LEFT(A1,LEN(A1)-1), LEFT(A1,LEN(A1)-2))

or:

=IF(ISERROR(FIND(".",A1)), LEFT(A1,LEN(A1)-1), LEFT(A1,LEN(A1)-3))

Thanks

Statistics: Posted by Gregory A. Chase — Tue Jul 29, 2014 11:05 am

]]>

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,

Statistics: Posted by Brian L. Chacon — Tue Jul 29, 2014 7:21 am

]]>