paperlined.org
apps > excel
document updated 2 months ago, on Jan 24, 2024
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