not sure what you are trying to do, get something in the 7th position
everytime? or do you want to know the location of a certain character? the
first would be
=MID(B1,7,1)
The second would be
=FIND(A1,B1)
A1 containing what you are looking for, B1 what you are looking in this will
only show the first location found.
If neither of these then please be more specific.

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"RSCARLISLE" wrote:

How do I extract the nth element of a string that contains no separators? I
can find plenty of VB routines doing this, however all of them require some
sort of separator. I want to be able to take a 10 to 15 digit alphanumeric
string and identify each character position and read the charater in that
position (including using * as a wild card).