Have you tried Mid, as in:
=mid(1,8,1)

Regards,
Fred.

"Charlie" wrote in message
...
I need a function that will pull a character value from a specified cell
and
string location so I can put it into an if statement to return a text
string.

i.e.
Say I have this text string, AP10-FG1A1P, and I wanted to pull the value
of
the 8th character. What do I use?

Find and Search are not returning the value, but only the position.
Right and Left return too many characters. Although they are good for the
first and last character value when needed.