String Manipulation

[crhodus]

I've gone through the VBA help, but I can't seem to find what I looking for. I know that it's in there. Can someone tell me what the name of the funciton that I need to use?

Dim MyString as String
Dim MyLetter as String

MyString = "ABCDEFG"
MyLetter = ???(3, MyString)

'What do I need to use so that MyLetter will equal the letter C?

Thanks!

 

[Mile-O]

The string functions off the top of my head are:

• Left(), Left$
• Right(), Right$
• Mid(), Mid$
• StrConv()
• UCase()
• LCase()
• InStr()
• Len()

The one you want is the Mid() or Mid$ function.

 

[crhodus]

Thanks for the info!