software

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

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

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

This should work.

Ian

quot;Sumeet Benawraquot; wrote:

gt; Hi
gt;
gt; I have a text string from which I would like to extract a particular value,
gt; that is the number at the end, and then convert it into an integer value. The
gt; String is;
gt;
gt; Total item(s) found: 1
gt;
gt; From which I want to be able to take the number at the end and convert it
gt; into an integer.
gt;
gt; Can anyone please assist in formulating a solution for doing that.
gt;
gt; Thanks
gt;
gt; Sumeet
gt;

Thanks Ian,

That hit the spot.

Sumeet

quot;Ian Pquot; wrote:

gt; Assuming that sometimes you are going to have numbers greater than 9:
gt;
gt; =RIGHT(A1,LEN(A1)-21)
gt;
gt; This should work.
gt;
gt; Ian
gt;
gt; quot;Sumeet Benawraquot; wrote:
gt;
gt; gt; Hi
gt; gt;
gt; gt; I have a text string from which I would like to extract a particular value,
gt; gt; that is the number at the end, and then convert it into an integer value. The
gt; gt; String is;
gt; gt;
gt; gt; Total item(s) found: 1
gt; gt;
gt; gt; From which I want to be able to take the number at the end and convert it
gt; gt; into an integer.
gt; gt;
gt; gt; Can anyone please assist in formulating a solution for doing that.
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Sumeet
gt; gt;