| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Numbers from a Cell that also has text.
I have numerous cells that have the following listed in them ... Item#
0012631004 How do I pull only the number out of this cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing Numbers from a Cell that also has text.
use edit find replace
find item# with a trailing space if there is one in your cells replace with leave this blank -- Greetings from New Zealand wrote in message ... I have numerous cells that have the following listed in them ... Item# 0012631004 How do I pull only the number out of this cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing Numbers from a Cell that also has text.
Hi I assume yo mean
Item#0012631004 in a cell so try this =MID(A1,6,LEN(A1)) Yo may have to change the 6 if there are spaces Mike " wrote: I have numerous cells that have the following listed in them ... Item# 0012631004 How do I pull only the number out of this cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| removing part of text string to another cell | Excel Discussion (Misc queries) | |||
| Removing characters from a cell (keeping only the numbers) | Excel Discussion (Misc queries) | |||
| Removing characters from a cell (keeping only numbers) 2 | Excel Discussion (Misc queries) | |||
| question about removing text from cells, leaving numbers | Excel Discussion (Misc queries) | |||
| Removing numbers from the beginning of a text string | Excel Worksheet Functions | |||
Linear Mode
