Text Functions

Question 1

This function converts a normal number to the character it represents in the ANSI character set used by Windows.

Answer 1

=CHAR

Question 2

This function removes any non-printable characters from text.

Answer 2

=CLEAN

Question 3

This function shows the ANSI value of a single character, or the first character in a piece

Answer 3

=CODE

Question 4

This function joins separate pieces of text into one item.

Answer 4

=CONCATENATE

Question 5

This function converts a number into a piece of text formatted as currency.

Answer 5

=DOLLAR

Question 6

This function compares two items of text and determine whether they are exactly the same.

Answer 6

=EXACT

Question 7

This function looks for a specified letter inside another piece of text.

Answer 7

=FIND

Question 8

This function converts a numeric value to text.

Answer 8

=FIXED

Question 9

This function displays a specified number of characters from the left-hand side of a piece of text.

Answer 9

=LEFT

Question 10

This function counts the number of characters, including spaces and numbers, in a piece of text.

Answer 10

=LEN

Question 11

This function converts all characters in a piece of text to lower case.

Answer 11

=LOWER

Question 12

This function picks out a piece of text from the middle of a text entry.

Answer 12

=MID

Question 13

This function converts the first letter of each word to uppercase, and all subsequent letters are converted to lowercase.

Answer 13

=PROPER

Question 14

This function replaces a portion of text with a new piece of text.

Answer 14

=REPLACE

Question 15

This function repeats a piece of text a specified number of times.

Answer 15

=REPT

Question 16

This function displays a specified number of characters from the right hand side of a piece of text.

Answer 16

=RIGHT

Question 17

This function replaces a specified piece of text with a different piece of text.

Answer 17

=SUBSTITUTE

Question 18

This function examines an entry to determine whether it is text or not.

Answer 18

=T

Question 19

This function converts a number to a piece of text.

Answer 19

=TEXT

Question 20

This function removes unwanted spaces from a piece of text.

Answer 20

=TRIM

Question 21

This function converts all characters in a piece of text to upper case.

Answer 21

=UPPER

Question 22

This function converts a piece of text which resembles a number into an actual value.

Answer 22

=VALUE