How can I remove the last 8 digits from every number


N

nkanaga

Hi all,

I have a spreadsheet, with about 1,500 lines. In column A is a list o
numbers that I need to remove the last 8 digit from each number, fo
example in A22 is 123456700000000 - I need this to be 1234567. Th
numbers are all not uniqe.

How can I remove the last 8 digits from every number, without going i
manually to do so?

Thank you
 
Ad

Advertisements

Hi

How about: =LEFT(A22,LEN(A22)-8)


nkanaga;1608152 said:
Hi all,

I have a spreadsheet, with about 1,500 lines. In column A is a list o
numbers that I need to remove the last 8 digit from each number, fo
example in A22 is 123456700000000 - I need this to be 1234567. Th
numbers are all not uniqe.

How can I remove the last 8 digits from every number, without going i
manually to do so?

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top