I want to isolate and remove all apostrophies "'" from the string "Jerry's House of Pancakes"(as you can tell I am craving food right now). I know you can do this with an array but every attempt I have made seems to fail. Any code would be helpful. This should be an easy 50 for someone : )
Dim myString as String
Dim thePos as Integer
Dim finalString as String
MyString = "Jerry's House.."
thePos = Instr(myString, "'") ' Returns the position
If thePos > 0 then 'Find '
FinalString = Left(MyString, thePos -1) & right(myString, Len(myString)-thePos)
If you have multiple, put it in a loop.
Regards
Dalin