| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
| Remove all but the last seven digits in a cell | Excel Discussion (Misc queries) | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
| remove and replace digits from a number | Excel Worksheet Functions | |||
| Remove ' if not followed by two digits | Excel Programming | |||
Threaded Mode
