Google Answers Logo
View Question
Q: Microsoft Excel help ( Answered,   0 Comments )
Subject: Microsoft Excel help
Category: Computers > Software
Asked by: bob_the_teacher-ga
List Price: $3.00
Posted: 12 Jul 2004 13:44 PDT
Expires: 11 Aug 2004 13:44 PDT
Question ID: 373171
I need an Excel formula that will take a column of numbers and letters
and remove the last four digits (of numbers and letters). Each cell in
the column looks similiar to this: 101094M059 and I just want: 101094
Subject: Re: Microsoft Excel help
Answered By: deadlychiapet-ga on 13 Jul 2004 20:21 PDT
Hi there,

The formula you need is =LEFT(A1, LEN(A1) - 4), with A1 being the cell
in question and the number 4 being the number of digits removed.

Hope that solves your problem, if not just ask for clarification.


Search strategy:
None, used prior knowledge
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy