Return nth decimal number

This tutorial shows how to extract the nth decimal number using an Excel formula, with the MID and FIND functions

EXCEL FORMULA 1. Return nth decimal number with MID and FIND functions

EXCEL

Hard coded formula
Return nth decimal number
Cell reference formula
Return nth decimal number
=MID(5.478,FIND(".",5.478)+2,1)
=MID(B7,FIND(".",B7)+$C$4,1)
GENERIC FORMULA

=MID(number,FIND(".",number)+nth_decimal,1)

ARGUMENTS
number: The number from which you want to return the nth decimal number.
nth_decimal: The nth decimal number that you want to return from a number.

GENERIC FORMULA

=MID(number,FIND(".",number)+nth_decimal,1)

ARGUMENTS
number: The number from which you want to return the nth decimal number.
nth_decimal: The nth decimal number that you want to return from a number.

EXPLANATION

This formula uses the FIND function to return the position of a full stop from a number and then adds a number that represents the nth decimal number that you want to return. The MID function is then used to return the number with a position calculated by the FIND function.

Click on either the Hard Coded or Cell Reference button to view the formula that has the nth decimal number and the number from which you want to return the nth decimal number directly entered into the formula or referenced to specific cells.

RELATED TOPICS

Related Topic Description Related Topic and Description
How to extract the first decimal number
How to extract the last decimal number

RELATED FUNCTIONS

Related Functions Description Related Functions and Description
The Excel FIND function returns the position of a specific sub-string within a string
The Excel MID function returns the specified number of characters from a selected string, starting at a specified position