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

"refresh" wrote:

Hiya,

I'm trying to find some info from a stream of data. There is a lot of info
and it varies from one line to next so I can't target set start points in the
string by using MID.

Ideally, from the following I would be able to pick out and return 1234567.

ancekdgkhglsdkgldfgkjdflgdg7890gafgagdfg205056agad gafgafg1234567adfgdfg32adfgadfg54gaadfgadga329adfg afgag654123afga

The number is arbitrary as it would be a different and unknown number in
every case. The only constant is the length and format of the string I'm
looking for. I've got 30,000+ of these strings and I'd like to know if there
is a way to pick out the number in excel or if there is something else i
should look at that might help.

I'd appreciate any assistance you can offer.

Many thanks.




Is what I'm asking possible and are there any quick ways to run this?