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 réponses

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