Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...
When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract a single digit number

Thread starter bines53
Start date Nov 18, 2014

B

bines53

Active Member

Nov 18, 2014

#1

Hello friends!

I want to extract single digit numbers,The second digit from the right
87548 =4
2154=5

Thank you !

Deepak

Excel Ninja

Nov 18, 2014

#2

=MID(A1,LEN(A1)-1,1)

Somendra Misra

Excel Ninja

Nov 18, 2014

#3

Hi David,

Try below formula:

=--RIGHT(INT(H3/10),1)

Number in H3.

Regards,

Debraj

Excel Ninja

Nov 18, 2014

#4

=MID(A1,MAX(1,LEN(A1)-1),1)

Just a validation, in case of len = 1

Somendra Misra

Excel Ninja

Nov 18, 2014

#5

@Debraj

Happy to see you back in action dada

Regards,

B

bines53

Active Member

Nov 18, 2014

#6

Thank you friends!

Regards,

David

You must log in or register to reply here.

Share:

Facebook X (Twitter) Reddit Pinterest Tumblr WhatsApp Email Link

Top