search string either Upper case or lower case
Is there a function can I use for this type of problem
First, I have to search for a particular string.
sComp = "Company list, The"
I want to search for a string ", The"
nPos = InStr(sComp , ", The")
My question is, sometimes the sComp = "Company list, THE"
and sComp = "Company list, ThE"