ExcelBanter - How can I remove the last 8 digits from every number

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How can I remove the last 8 digits from every number (https://www.excelbanter.com/new-users-excel/447871-how-can-i-remove-last-8-digits-every-number.html)

nkanaga

How can I remove the last 8 digits from every number

Hi all,

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

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

Thank you!

Kevin@Radstock

Hi

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

Quote:

Originally Posted by nkanaga (Post 1608152)

All times are GMT +1. The time now is 09:52 PM.