paperlined.org
apps > excel
document updated 21 days ago, on Jun 10, 2022
The fact that there are two different function names to do anything in Excel can get confusing.

Overall Excel function reference. TODO: Find the reference for Office VBA functions.

VBA Excel description
Strings
& &
concatenate("foo", "bar", "!")
String concatenation
? asc("abc") = "abc" Convert full-width characters to half-width; you're probably looking for code() instead.
asc("A") = 65 code("A") = 65 Convert character → number.
chr(65) = "A" char(65) = "A" Convert number → character.
trim()
rtrim()
ltrim()
trim() Remove leading and trailing spaces.
mid()
left()
right()
mid()
left()
right()
Return the specified sub-string
instr(haystack, needle)>0 Not(IsError(find(needle, haystack)))
[case sensitive]
Not(IsError(search(needle, haystack)))
[case insensitive]
Search for a substring.
instrrev(haystack, needle) not possible without hacks [2] [3] Search backwards for a substring.
replace()
replaceb()
Replace substring based on position + length.
substitute() Find-and-replace substring.
StrConv(vbUpperCase)
StrConv(vbLowerCase)
StrConv(vbProperCase)
upper()
lower()
proper()
Convert to upper or lower case.
Explicit type conversion
val()
cint()
clng()
cdbl()
value() String → number
format()
str()
cstr()
fixed()
text()
Number → string
DateValue() datevalue() String → date
TimeValue() timevalue() String → time
Math
mod operator mod(num,divisor) Modulus



Categorized list of functions