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

Need help removing extra TOC text from number lists used as TOC levels 0
Macro to Select text from a point given to a specific word 2
Calculate the median value before a specified list 0
Justification function versus wide spaces 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Creating a Search using a combo box and then creating a report. 4
Function or Sub to help with text string 5
Problem with SET & REF function 0

Top