Capture The Character at 'x' position in a string

[Ark68]

I have a string (serv_str) = PL [SD] WD PT
Variable srvtext = "SD"

I can get the position (sp) of servtxt in the string serv_st using

sp = InStr(serv_str, srvtext)

sp = 5
I am looking for help finding a VBA solution that will return the character at sp-1, in this case, "["

 

[Fluff]

How about

Mid(serv_str,sp-1,1)

 

[Ark68]

Yes! Thats what I was looking for. Totally forgot about left, mid and right operations.
Thank you Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.