Text Functions

Question 1

EXACT(text1,text2)

Answer 1

Compares two text strings and returns TRUE if they are exactly the same, otherwise returns FALSE. EXACT is case-sensitive but ignores formatting differences. EXACT is case-sensitive

Question 2

CONCATENATEX(table, expression[, delimiter [, orderBy_expression [, order]]…])

Answer 2

Concatenates the result of an expression evaluated for each row in a table.

Question 3

VALUE(text)

Answer 3

Converts a text string that represents a number to a number.

Question 4

UPPER (text)

Answer 4

Converts a text string to all uppercase letters.

Question 5

FORMAT(value, format_string[, locale_name])

Answer 5

Converts a value to text according to the specified format.

Question 6

LOWER(text)

Answer 6

Converts all letters in a text string to lowercase.

Question 7

COMBINEVALUES(delimiter, expression, expression[, expression]…)

Answer 7

Joins two or more text strings into one text string. The primary purpose of this function is to support multi-column relationships in DirectQuery models. See Remarks for details.

Question 8

CONCATENATE(text1, text2)

Answer 8

Joins two text strings into one text string.

Question 9

TRIM(text)

Answer 9

Removes all spaces from text except for single spaces between words.

Question 10

REPT(text, num_times)

Answer 10

Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.

Question 11

REPLACE(old_text, start_num, num_chars, new_text)

Answer 11

REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.

Question 12

SUBSTITUTE(text, old_text, new_text, instance_num)

Answer 12

Replaces existing text with new text in a text string.

Question 13

MID(text, start_num, num_chars)

Answer 13

Returns a string of characters from the middle of a text string, given a starting position and length.

Question 14

UNICODE( Text )

Answer 14

Returns the number (code point) corresponding to the first character of the text.

Question 15

LEN(text)

Answer 15

Returns the number of characters in a text string.

Question 16

SEARCH(find_text, within_text[, [start_num][, NotFoundValue]])

Answer 16

Returns the number of the character at which a specific character or text string is first found, reading left to right. Search is case-insensitive and accent sensitive.

Question 17

LEFT(text, num_chars)

Answer 17

Returns the specified number of characters from the start of a text string.

Question 18

FIND(find_text, within_text[, [start_num][, NotFoundValue]])

Answer 18

Returns the starting position of one text string within another text string. FIND is case-sensitive.

Question 19

UNICHAR(number)

Answer 19

Returns the Unicode character referenced by the numeric value.

Question 20

RIGHT(text, num_chars)

Answer 20

RIGHT returns the last character or characters in a text string, based on the number of characters you specify.

Question 21

FIXED(number, decimals, no_commas)

Answer 21

Rounds a number to the specified number of decimals and returns the result as text. You can specify that the result be returned with or without commas.