Need a Function

[Charlie]

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

 

[Fred Smith]

See your other post. Multi-posting is not necessary in these groups.

Regards,
Fred.

 

[Shane Devenshire]

Hi,

Haven't checked your other post but...

=MID(A1,4,1)

 

[Gord Dibben]

=MID(string,startnum,numchars)

=MID("Charlie",4,1)

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


Gord Dibben MS Excel MVP