VBA: Find and Replace in a String

=========
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

By | 2017-12-01T23:47:34+00:00 December 7th, 2011|Access, Computers, Documentation, Microsoft, VBA|0 Comments