text functions (part two)

what is the function that used to merge the text in two different cells or more in one cell

• trim

• sum

• concatenate

• left

what is the function that used to compare the text in two different cells

• concatenate

• exact

• proper

• trim

what is the function that used to convert number to text data type with fixed number of numbers behind the decimal point

• proper

• trim

• concat

• fixed

what is the function that used to set text in specific cell to upper case in other cell

• lower

• concat

• upper

• proper

what is the function that used to set the text in specific cell in lower case in other cell

• upper

• proper

• lower

• fixed

what is the function that capitalize the first letter of each word in specific cell in other cell

• proper

• concat

• lower

• fixed

what is the function that replace some characters in specific cell in other cell based on starting point and number of replaced characters

• lower

• upper

• replace

• concat

what is the function that remove extra spaces from text

• upper

• lower

• trim

• fixed

what is the function that used for repeating text in specific cell in other cell for specific number of times

• rept

• text

• right

• left