| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding a numerical value within a cell
I am trying to extract all the characters after a numerical value in a cell.
The numerical value can be any number and at various positions within the cell. The text after the number varies. Here are some examples of the cells. NOVELS 8 FT 7 Shelf ROMANCE 8 FT 7 Shelf YR-TEEN 8ft 78in I've thought of the find, mid, left, right functions but that all require using a set number to search for or extracting based on a set number of characters. Any way to do this? Any help is appreciated. Thanks!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding a numerical value within a cell
Are you saying that you want to return *only* "in" from your last example?
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Cecilia" wrote in message ... I am trying to extract all the characters after a numerical value in a cell. The numerical value can be any number and at various positions within the cell. The text after the number varies. Here are some examples of the cells. NOVELS 8 FT 7 Shelf ROMANCE 8 FT 7 Shelf YR-TEEN 8ft 78in I've thought of the find, mid, left, right functions but that all require using a set number to search for or extracting based on a set number of characters. Any way to do this? Any help is appreciated. Thanks!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding a numerical value within a cell
I'm trying to extract all characters after the numerical values including the
number. Column 1 is the original column and column 2 is the desired outcome. So for the Column 1 Column 2 NOVELS 8 FT 7 Shelf 8 FT 7 Shelf ROMANCE 8 FT 7 Shelf 8 FT 7 Shelf YR-TEEN 8ft 78in 8ft 78in "RagDyeR" wrote: Are you saying that you want to return *only* "in" from your last example? -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Cecilia" wrote in message ... I am trying to extract all the characters after a numerical value in a cell. The numerical value can be any number and at various positions within the cell. The text after the number varies. Here are some examples of the cells. NOVELS 8 FT 7 Shelf ROMANCE 8 FT 7 Shelf YR-TEEN 8ft 78in I've thought of the find, mid, left, right functions but that all require using a set number to search for or extracting based on a set number of characters. Any way to do this? Any help is appreciated. Thanks!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding a numerical value within a cell
Try this:
=MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&"1234567 890")),125) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Cecilia" wrote in message ... I'm trying to extract all characters after the numerical values including the number. Column 1 is the original column and column 2 is the desired outcome. So for the Column 1 Column 2 NOVELS 8 FT 7 Shelf 8 FT 7 Shelf ROMANCE 8 FT 7 Shelf 8 FT 7 Shelf YR-TEEN 8ft 78in 8ft 78in "RagDyeR" wrote: Are you saying that you want to return *only* "in" from your last example? -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Cecilia" wrote in message ... I am trying to extract all the characters after a numerical value in a cell. The numerical value can be any number and at various positions within the cell. The text after the number varies. Here are some examples of the cells. NOVELS 8 FT 7 Shelf ROMANCE 8 FT 7 Shelf YR-TEEN 8ft 78in I've thought of the find, mid, left, right functions but that all require using a set number to search for or extracting based on a set number of characters. Any way to do this? Any help is appreciated. Thanks!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding a numerical value within a cell
Thanks for your response. I tried this and it returns a 10 for every cell.
"RagDyeR" wrote: Try this: =MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&"1234567 890")),125) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Cecilia" wrote in message ... I'm trying to extract all characters after the numerical values including the number. Column 1 is the original column and column 2 is the desired outcome. So for the Column 1 Column 2 NOVELS 8 FT 7 Shelf 8 FT 7 Shelf ROMANCE 8 FT 7 Shelf 8 FT 7 Shelf YR-TEEN 8ft 78in 8ft 78in "RagDyeR" wrote: Are you saying that you want to return *only* "in" from your last example? -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Cecilia" wrote in message ... I am trying to extract all the characters after a numerical value in a cell. The numerical value can be any number and at various positions within the cell. The text after the number varies. Here are some examples of the cells. NOVELS 8 FT 7 Shelf ROMANCE 8 FT 7 Shelf YR-TEEN 8ft 78in I've thought of the find, mid, left, right functions but that all require using a set number to search for or extracting based on a set number of characters. Any way to do this? Any help is appreciated. Thanks!! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Finding a numerical value within a cell
Post the *exact* formula that you're using.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Cecilia" wrote in message ... Thanks for your response. I tried this and it returns a 10 for every cell. "RagDyeR" wrote: Try this: =MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&"1234567 890")),125) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Cecilia" wrote in message ... I'm trying to extract all characters after the numerical values including the number. Column 1 is the original column and column 2 is the desired outcome. So for the Column 1 Column 2 NOVELS 8 FT 7 Shelf 8 FT 7 Shelf ROMANCE 8 FT 7 Shelf 8 FT 7 Shelf YR-TEEN 8ft 78in 8ft 78in "RagDyeR" wrote: Are you saying that you want to return *only* "in" from your last example? -- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "Cecilia" wrote in message ... I am trying to extract all the characters after a numerical value in a cell. The numerical value can be any number and at various positions within the cell. The text after the number varies. Here are some examples of the cells. NOVELS 8 FT 7 Shelf ROMANCE 8 FT 7 Shelf YR-TEEN 8ft 78in I've thought of the find, mid, left, right functions but that all require using a set number to search for or extracting based on a set number of characters. Any way to do this? Any help is appreciated. Thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting numerical values within a cell | Excel Worksheet Functions | |||
| Conditional Formatting; finding numerical data in mixed text. | Excel Discussion (Misc queries) | |||
| In cell drop down menu with seprerate numerical target cell | Excel Discussion (Misc queries) | |||
| How can I insert numerical bullets in a cell ex: 1a) ? | Excel Discussion (Misc queries) | |||
| Numerical characters in a cell | Excel Discussion (Misc queries) | |||
Linear Mode
