Delete numbers within cells
 

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.

Delete numbers within cells
 

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.

Delete numbers within cells
 

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.

Delete numbers within cells
 

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.

Delete numbers within cells
 

Do you want the id number to be 5 characters in all cases? or will that vary?
If 5 characters:

=LEFT(D2,5)


"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.

Delete numbers within cells
 

Sorry for the long delay, but thank you both very much. This saved me
mountains of time.

"Gary''s Student" wrote:

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.