String manipulation keyword summary

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, InStrRev, Left, LTrim, Mid, Right, RTrim, Trim
Set string comparison rules.	Option Compare
Work with ASCII and ANSI values.	Asc, Chr

See also

• Keywords by task

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.