Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
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 = 5
I am looking for help finding a VBA solution that will return the character at sp-1, in this case, "["
Variable srvtext = "SD"
I can get the position (sp) of servtxt in the string serv_st using
Code:
sp = InStr(serv_str, srvtext)
I am looking for help finding a VBA solution that will return the character at sp-1, in this case, "["