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

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

## Comment