Strings: Index Of Articles

Parse one field's data into multiple fields

How to "break" the values in one field (say, Name) in multiple fields (FirstName, LastName)

Extract characters from a string containing both numbers and characters

How to extract characters from a string containing both numbers and characters

Parsing character separated string into individual components

How to tokenize strings 

Replace a character with another within one string

How to replace a character

Capitalize first character of every word automatically

Use StrConv in VBA5+ or a custom function in prior versions to proper case a word

Convert all text to Upper-Lower case

Use LCase or UCase to switch between cases

Increment Numeric portion of a string

Use concatenation and Right$ to deal with a number separately

Names with Mixed cases

How to proper case words taking into account names with mixed case (eg. McPherson)