Extracting a number from a string and converting it into an Intege
 

Hi

I have a text string from which I would like to extract a particular value,
that is the number at the end, and then convert it into an integer value. The
String is;

Total item(s) found: 1

From which I want to be able to take the number at the end and convert it
into an integer.

Can anyone please assist in formulating a solution for doing that.

Thanks

Sumeet

Extracting a number from a string and converting it into an Intege
 

Assuming that sometimes you are going to have numbers greater than 9:

=RIGHT(A1,LEN(A1)-21)

This should work.

Ian

"Sumeet Benawra" wrote:

Hi

I have a text string from which I would like to extract a particular value,
that is the number at the end, and then convert it into an integer value. The
String is;

Total item(s) found: 1

From which I want to be able to take the number at the end and convert it
into an integer.

Can anyone please assist in formulating a solution for doing that.

Thanks

Sumeet

Extracting a number from a string and converting it into an In
 

Thanks Ian,

That hit the spot.

Sumeet

"Ian P" wrote:

Assuming that sometimes you are going to have numbers greater than 9:

=RIGHT(A1,LEN(A1)-21)

This should work.

Ian

"Sumeet Benawra" wrote:

Hi

I have a text string from which I would like to extract a particular value,
that is the number at the end, and then convert it into an integer value. The
String is;

Total item(s) found: 1

From which I want to be able to take the number at the end and convert it
into an integer.

Can anyone please assist in formulating a solution for doing that.

Thanks

Sumeet