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))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|