VBA: String Manipulation

=========
QUESTION
———
What are some ways I can manipulate strings within VBA?

 

=========
ANSWER
———
see EXAMPLES

 

=========
EXAMPLES
———
Title field has values like: Company Manager, Company Assoc, Company Director, etc…
Remove Company:
=IIf([Title] is null,””,Replace([Title],”Company “,””))

 

=========
APPLIES TO / KEY WORDS
———
Microsoft Access
String Manipulation
Strings
VBA

 

=========
REF
———
http://dmcritchie.mvps.org/excel/strings.htm

 


http://anySiteSupport.com
http://anySiteHosting.com

By | 2011-10-25T10:23:53+00:00 October 25th, 2011|Access, Computers, Documentation, Microsoft, VBA|0 Comments