Function |
Execution |
Desired Result |
Correct? |
Notes |
ASC |
|
87 |
|
|
ASC |
|
87 |
|
|
ASC |
|
120 |
|
|
CHAR |
|
v |
|
|
CHAR |
|
@ |
|
|
CHAR |
|
H |
|
|
CHAR |
|
m |
|
|
CLEAN |
|
test |
|
|
CODE |
|
116 |
|
t |
CONCATENATE |
|
a complete string |
|
|
CONCATENATE |
|
An escaped string |
|
|
DOLLAR |
|
12312.23 |
|
|
DOLLAR |
|
12312.23 |
|
|
DOLLAR |
|
12312.23 |
|
|
FIXED |
|
12312.2 |
|
|
FIXED |
|
12312.2 |
|
|
FIXED |
|
35124 |
|
|
LEFT |
|
AaBbC |
|
|
LEFT |
|
A |
|
|
LEN |
|
52 |
|
|
LOWER |
|
aabbccddeeffgghhiijjkkllmmnnooppqqrrssttuuvvwwxxyyzz |
|
|
MID |
|
CcDd |
|
|
REPLACE |
|
AaBb:)EeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz |
|
|
REPT |
|
abcdabcdabcd |
|
|
REPT |
|
abcdabcdabcd |
|
|
RIGHT |
|
xYyZz |
|
|
SEARCH |
|
21 |
|
|
SEARCH |
|
21 |
|
|
SEARCH |
|
#VALUE! |
|
|
SUBSTITUTE |
|
AABBCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz |
|
|
SUBSTITUTE |
|
AABBCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz |
|
|
SUBSTITUTE |
|
AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz |
|
|
UPPER |
|
AABBCCDDEEFFGGHHIIJJKKLLMMNNOOPPQQRRSSTTUUVVWWXXYYZZ |
|
|
VALUE |
|
987.65 |
|
|
VALUE |
|
#VALUE! |
|
|
VALUE |
|
9 |
|
|
FIND |
|
1 |
|
|
FIND |
|
|
|
|
FIND |
|
3 |
|
|
FIND |
|
4 |
|
|