Removal of "dot" following last digit

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


--
Thanks,
Tom

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.


Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Tom" wrote in message
...
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


--
Thanks,
Tom

Norman,

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

--
Thanks,
Tom


"Norman Harker" wrote in message
...
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.


Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Tom" wrote in message
...
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


--
Thanks,
Tom

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.


Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Tom" wrote in message
...
Norman,

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

--
Thanks,
Tom


"Norman Harker" wrote in message
...
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.


Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Tom" wrote in message
...
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


--
Thanks,
Tom