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

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

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

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

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

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