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