listi.net

String or Text Processing

String Functions

Left()

Right()

Trim()

Mid()

Instr()

LCase() / UCase()

Split( )

Concatenation - &

Replace( )

Len()

Split()

Ex.

Have a message in a Cell with a date tag < date> and replace it with the current date

smessage = sMessage & Thisworkbook.Sheets("Main").Range("DER_email")

GetMessage = Replace(sMessage, "< date>", formate(Now(), "mmm, d, yyyy"))

Variables

Check for Acronyms

Get Unique from a list

CompareText(t1, t2)

RemoveLastComma

CountIfString

GetPMOK