VBA für Excel

Befehle zur Manipulation von Strings

ActionLanguage element
Compare two strings.StrComp
Convert strings.StrConv
Reverse a string.InStrRev, StrReverse
Convert to lowercase or uppercase.Format, LCase, UCase
Create a string of repeating characters.Space, StrDup
Find the length of a string.Len
Format a string.Format, FormatCurrency, FormatDateTime, FormatNumber, FormatPercent
Manipulate strings.InStr, Left, LTrim, Mid, Right, RTrim, Trim
Set string comparison rules.Option Compare
Work with ASCII and ANSI values.Asc, AscW, Chr, ChrW
Replace a specified substring.Replace
Return a filter-based string array.Filter
Return a specified number of substrings.Split, Join

Diskussion