=MID(string,startnum,numchars)

=MID("Charlie",4,1)

Or =MID(A1,4,1) if Charlie is in A1


Gord Dibben MS Excel MVP

On Tue, 23 Jun 2009 07:34:01 -0700, Charlie
wrote:

I need to retrieve a character value from a given position within a text
string, how would I do that?

For example, I want to pull the value of the 4th character form the word
Charlie. The value would be r. What function does this?

Find and Search only return the position number of the specified character.

Thanks