Need Help with Large Spreadsheet

[DMadden]

Hi there,

I have recently been sent a large spreadsheet with close to ten thousand lines on it. I have been given the job of finding a quick and easy way of amending each line.

Whats needs done:
A cell in every record (line) has a 12 digit number but this needs to be reduce to a 9 digit number . i.e. the last 3 digits of every every number needs to be removed.

Can anyone advise of an easier way than going down the sheet one by one and deleting the last three digits of each number for the next week.

Let me know if this does not make sense to anyone. Any help will be very much appreciated.

Many Thanks peeps!

[oldchippy]

If your numbers are in column A, then in B1 put this and drag the formula downwards

=LEFT(A1,9)

[DMadden]

Thats perfect mate but would you know how to also remove numbers from each end and just leave the digits in the middle.

i.e I have 000956760020
and these needs to become 95676??

Cheers very much, you first answer has been a huge help!

[oldchippy]

Do all the remaining numbers have 3 zero's in front? If so try

=MID(A1,4,5)

[DMadden]

Cheers very much mate, you have just saved me from going senile over a ten thousand line spreadsheet.

I need to get myself on an excel course.

Thanks again!!

[oldchippy]

Glad to help - thanks for the feedback