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