Question:

How to extract the numeric value from the eighth character from a cell in excel?

by  |  earlier

0 LIKES UnLike

please help me

 Tags:

   Report
Answer The Question I've Same Question Too

1 ANSWERS

Sort By: Date  |  Rating

  1. If the original value is in cell A1...

    =MID(A1,8,1)

    Granted, this will simply return the value of the 8th character. If you want something more complex, you will need to write a VBA function

You're reading: How to extract the numeric value from the eighth character from a cell in excel?

Question Stats

Latest activity: earlier.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now