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
 
K

Kevin@Radstock

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
Click to expand...
 

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

Similar Threads

How can the font and size of (all) citation numbers be altered? 1
Can I have Excel Show the last 8 digits of a Number? 6
Finding the right style field in VBA 0
Truncating Number Series 3
LOOKUP function help 6
How can I copy data produced by a formula, not the formula? 2
Validation of UK VAT Number 21
Extract phone number from word file 2

Top