View original (French)

Extracting a part of a number in EXCEL

Solved
william -  
 mpfl46 -
Hello,

I would like to in Excel - in a cell containing a 14-digit number, extract or copy the 8th and 9th digits into the adjacent column.

EX: base number = 12345678900015
adjacent column = 89

Is this possible?

What formula???

THANK YOU

2 answers

  1.
    chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
     
    Hello,

    to extract data from A1 the 8th and 9th columns, put in B2: 

    =MID(A2,8,2)

    then click and drag to apply it to the whole column.

    Best regards.
    --
    If we were to lock all the idiots in cupboards,
    there would be no one left to close the doors.
    18
    1. william
       
      IT WORKS !!!!! AMAZING AMAZING AMAZING THANK YOU .........

      IT'S GOING TO CHANGE MY LIFE ......... LIKE THEY SAY, SOMETIMES IT DOESN'T TAKE MUCH

      ......BUT WHEN YOU DON'T KNOW, YOU DON'T KNOW !!!

      THANK YOU AGAIN
      0
    2. chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
       
      You're welcome, the pleasure is all mine.
      0
    3. mimi
       
      a big thank you from 2020
      0
    4. mpfl46
       
      Thank you for a simple and very effective response!!
      0
  2. abdout Posted messages 22 Status Member 17
     
    je ne pourrai pas vous aider désolé
    -2
    1. Polux31 Posted messages 7219 Status Member 1 204
       
      It's nice to say that we can't count on you... that really helps ^^
      0
    2. chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
       
      This is what we call relevant interventions (this is not his first intervention of this kind).
      0