Remove four digits from the right

[scotth]

Good morning,

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
For example

331884
4161895
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]

Try this.

=LEFT(A4,LEN(A4)-4)

[thomach]

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:
=VALUE(LEFT(A4,LEN(A4)-4))

=--LEFT(A4,LEN(A4)-4)

[scotth]

Thank you! That is exactly what I was looking for.


- - -Scott