I have a list of item numbers that I need to remove the last four digits and leave the remainder to the left. I have a formula that will count over from the left three digits and show those three digits only, but there are times that all item numbers do not have the same amount of digits. What they do have in common is that it is always the digits before the last four digits
What I need is 33 and 416. Is there a formula that I can use that will remove the four digits on the right?
I have attached a sample.
Thank you for taking time to help. I appreciate it.
- - -Scott
norie's formula will provide the result in TEXT format. You can generally use the result in a formula (as a number) but will have problems if you do things like test to see if it is equal to another cell with a number in it (like in an IF statement). If this might be an issue for future use of the cell's content and you want a number (format) returned, use either:
Last edited by thomach; February 14th, 2006 at 01:27. Reason: add formula variation
Please help Oz share knowledge among all users by posting your questions in a public forum rather than using a Private Message.
There are currently 3 users browsing this thread. (0 members and 3 guests)