Removal of "dot" following last digit

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
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.
 
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.
 
Back
Top