Extract part of a cell value

G

GazMo

I have a column of numbers (each of 8 digits) and i want to extract i
another column only the 3rd and 4th digits (eg 12345678 - shoul
produce 34). Can anyone give me some code to help me
 
E

ElsiePOA

Assuming your numbers are in column A, in cell B2 enter the formul
=MID(A1,3,2) and copy down the column. This assumes that you alway
want the 3rd and 4th digets. :cool
 
C

Corey

There probably is a formula, but if it's exactly 8 digits
in every cell, then a quick & easy way would be to go to

Data>Text to Columns

Click on Fixed Width and then Next

Align the breaks between the third & fourth digits, then
Finish.

Hope this helps.
 
R

Ron Rosenfeld

I have a column of numbers (each of 8 digits) and i want to extract in
another column only the 3rd and 4th digits (eg 12345678 - should
produce 34). Can anyone give me some code to help me ?
Click to expand...


=MOD(INT(A1/10^4),100)


--ron
 
Top