Need a Function

C

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
 
F

Fred Smith

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

Regards,
Fred.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Functions 6
IF function 4
Find the UPPERCASE letter in a string 9
VLOOKUP source values are a formula result. Getting #N/A 7
FIND function does not return ZERO when text is not found 5
Find function 6
Find position of first non-matching character 18
return a character at a certain position in a string of text 2

Top