Excel Question....Deleting Numbers In a Set

[Jac]

I have a set of numbers, ex: 43441900 However, I only want to keep the 4
numbers in the middle (4419). How do I delete the 1st set of numbers (43)
and the last set of numbers (00)? I need to copy this format in over 1000
rows.

I need help quickly. I have to present a report to my boss as soon as
possible.

Version...Excel 2003
Thanks

 

[Rick Rothstein \(MVP - VB\)]

Are your numbers really numbers or are they text that look like numbers? I
ask because we need to know what is in the cell when the number has leading
zeroes like this.... 00123456.

Rick

 

[David Biddulph]

If they are all 8 digit numbers, then =MID(A2,3,4) if you want the output as
text, or =--MID(A2,3,4) if you want a number.

 

[Ron Rosenfeld]

I have a set of numbers, ex: 43441900 However, I only want to keep the 4
numbers in the middle (4419). How do I delete the 1st set of numbers (43)
and the last set of numbers (00)? I need to copy this format in over 1000
rows.

I need help quickly. I have to present a report to my boss as soon as
possible.

Version...Excel 2003
Thanks

See if this does what you want:

=MOD(INT(A1/100),10000)

--ron