| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average only cells that contain numbers | Excel Worksheet Functions | |||
| Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
| Finding most common occurence of values in cells containing letters and numbers | Excel Worksheet Functions | |||
| Code to delete rows and column cells that have formulas in. | Excel Worksheet Functions | |||
| question about removing text from cells, leaving numbers | Excel Discussion (Misc queries) | |||
Linear Mode
