B
beginner here
In col F cell 2, I have a number that is ten characters long, and this number
could remain the same for up to 20 or 30 rows with additional information on
either side of this number, but then this number will change to a different
number (number will always be ten characters long) for up to the same 20 or
30 rows, this format will continue for about another 200 rows or so.
So what I am needing is a formula that will locate the first occurence of
this number, so that I can then access the remaining portion of this
information.
Steve
could remain the same for up to 20 or 30 rows with additional information on
either side of this number, but then this number will change to a different
number (number will always be ten characters long) for up to the same 20 or
30 rows, this format will continue for about another 200 rows or so.
So what I am needing is a formula that will locate the first occurence of
this number, so that I can then access the remaining portion of this
information.
Steve