If a cell (say A1) contains 0010002 then
=LEFT(A1,5)
will return
00100 last two digits removed

or


=LEFT(A1,4) will return
0010 last three digits removed


--
Gary's Student


"Jason" wrote:

Sorry; here you go:

c b a ID #
8 5 17.0% 0010002


Ideally, I would like to delete the last 2-3 numbers in the ID# cell for
each of the 1800+ cases.

"Gary''s Student" wrote:

Give us one or two examples of what you have.
--
Gary's Student


"Jason" wrote:

I have over 1800 rows of data that are sorted by ID number. The problem is
the column with the ID number has 2-3 extra numbers; Is there a way to delete
the extra numbers in each row? I've tried ASAP utilities to no avail. I'm new
to Excel so please keep that in mind when offering any much needed and
appreciated advice.