Excel Question....Deleting Numbers In a Set
 

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

Excel Question....Deleting Numbers In a Set
 

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


"Jac" wrote in message
...
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

Excel Question....Deleting Numbers In a Set
 

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.
--
David Biddulph

"Jac" wrote in message
...
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

Excel Question....Deleting Numbers In a Set
 

On Tue, 19 Aug 2008 10:00:21 -0700, Jac wrote:

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