String Manipulation Keyword Summary

Last modified: March 09, 2015

Applies to: Office 2013 | VBA

Action

Keywords

Compare two strings.

StrComp

Convert strings.

StrConv

Convert to lowercase or uppercase.

Format, Lcase, Ucase

Create string of repeating character.

Space, String

Find length of a string.

Len

Format a string.

Format

Justify a string.

LSet, Rset

Manipulate strings.

InStr, Left, LTrim, Mid, Right, RTrim, Trim

Set string comparison rules.

Option Compare

Work with ASCII and ANSI values.

Asc, Chr

Show:
© 2015 Microsoft