software

From that example, how is it that you determined you wanted the 1234567 from
the data as opposed to the 205056 or any of the other number sequences in
that data?

Is the length of the number always 7 digits?
Is it always the 2nd seven digit number in the stream?

Bill

quot;refreshquot; wrote:

gt; Hiya,
gt;
gt; I'm trying to find some info from a stream of data. There is a lot of info
gt; and it varies from one line to next so I can't target set start points in the
gt; string by using MID.
gt;
gt; Ideally, from the following I would be able to pick out and return 1234567.
gt;
gt; ancekdgkhglsdkgldfgkjdflgdg7890gafgagdfg205056agad gafgafg1234567adfgdfg32adfgadfg54gaadfgadga329adfg afgag654123afga
gt;
gt; The number is arbitrary as it would be a different and unknown number in
gt; every case. The only constant is the length and format of the string I'm
gt; looking for. I've got 30,000 of these strings and I'd like to know if there
gt; is a way to pick out the number in excel or if there is something else i
gt; should look at that might help.
gt;
gt; I'd appreciate any assistance you can offer.
gt;
gt; Many thanks.
gt;
gt;
gt;
gt;
gt; Is what I'm asking possible and are there any quick ways to run this?