Trimming numbers

[Kylor]

I am using Excel 2000. I have a list of numbers that are 12 characters long. If the actual number does not take up all 12 places the space is left blank.
For example:
123456789 3
123456789123

What I need to do is to delete the first two digits of every line and also the last digit. So I would end up with:
3456789
345678912

Thanks

 

[yoelpa]

I think I can help you but explain more

 

[Kylor]

Thanks, I need to take off the first two digits and the last one off of a 12 digit long number. I guess there must be some kind of trim function?

 

[yoelpa]

=MID(A1,3,9)

 

[Kylor]

Excellent, I knew there had to be a simple way!

 

[IML]

if what you are using works, stick with it. But based on your first example, you may need to expand it a little to
=MID(LEFT(A1,FIND(" ",A1&" ")),3,9)+0

good luck