Find a character in a string

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 : )
gcwAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DalinConnect With a Mentor Commented:
Try:

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
0
 
gcwAuthor Commented:
See I told ya it would be an easy 50 points.. thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.