How can I remove the last 8 digits from every number

Kevin@Radstock Kevin@Radstock is offline

Member

Posts: 93

Hi

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

Quote:

Originally Posted by nkanaga

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA write macro change column with 3 number digits to 4 digits the	James C[_2_]	Excel Discussion (Misc queries)	3	January 25th 10 03:12 PM
Remove all but the last seven digits in a cell	Gary Crisp	Excel Discussion (Misc queries)	10	February 12th 08 07:59 PM
How to customize number to 10 digits including 2 digits after deci	Carina	Excel Worksheet Functions	3	September 20th 07 02:50 AM
remove and replace digits from a number	spreadsheet monkey	Excel Worksheet Functions	3	April 20th 07 02:08 PM
Remove ' if not followed by two digits	tom[_7_]	Excel Programming	2	January 9th 06 06:03 PM

All times are GMT +1. The time now is 05:42 PM.

Menu

About Us