=========
QUESTION
———
How do I do a find and replace within a string using VBA?
How do I replace a character in a string?
=========
ANSWER
———
see EXAMPLES
=========
EXAMPLES
———
Sometimes you will stumble across someone having entered a phone number in a database with a “/” between the area code and the 7 digit number. You can use this bit of code to find and replace the / with a –
Replace(
[HM_PHONE_NBR],”/”,”-“)
=========
APPLIES TO / KEY WORDS
———
String
Strings
Manipulation
Find and Replace
=========
REF
———
http://www.tek-tips.com/faqs.cfm?fid=418
—
http://www.anysitesupport.com/vba-find-and-replace-in-a-string/
http://anySiteHosting.com