Removal of "dot" following last digit

[Tom]

Does anyone know of any function that removes a "dot" following the last
digit (see sample data below).

Data sample BEFORE removal of last "dot":
1.1
1.1.1. has "dot" following the last digit
1.2. has "dot" following the last digit
1.2.1

Data sample AFTER removal of last digit:
1.1
1.1.1 last "dot" has been removed
1.2 last "dot" has been removed
1.2.1

 

[Norman Harker]

Hi Tom!

Try:

=IF(RIGHT(A1,1)=".",LEFT(A1,LEN(A1)-1),A1)

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Tom]

Norman,

thanks so much... this works really great!!!!

 

[Norman Harker]

Hi Tom!

Always pleased to help and Google Searchers find it useful to know a
solution works "as advertised".

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.