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!!
|