Excel Text Functions

Before you begin view this resource: https://www.excelfunctions.net/excel-text-functions.html

Which text function is used to remove duplicate spaces and spaces at the start or end of a text string?

• TRIM

• TEXTJOIN

• MID

• LEFT

• UPPER

Which text function is used to join together two or more strings of text and is best used when you do not have a symbol delimiter?

• TRIM

• TEXTJOIN

• MID

• CONCAT

• UPPER

Which text function is used to join together two or more strings of text and is best used when you have a separation delimiter? (This is New to Excel 2019)

• TRIM

• TEXTJOIN

• MID

• CONCAT

• UPPER

Which text function is used to count the number of characters contained in a text string?

• TRIM

• LEN

• MID

• LOWER

• UPPER

Which text function is used to return a specified number of characters from the middle of a supplied text string?

• TRIM

• LEN

• MID

• LOWER

• UPPER

Which text function is used to return a specific number of characters from the start of the supplied text string?

• LEFT

• LEN

• RIGHT

• LOWER

• UPPER

Which text function is used to return a specific number of characters from the end of the supplied text string?

• LEFT

• LEN

• RIGHT

• LOWER

• UPPER

Which text function is used to convert a string of text so all characters are lower case?

• LEFT

• PROPER

• RIGHT

• LOWER

• UPPER

Which text function is used to convert a string of text so all characters are capital letters?

• LEFT

• PROPER

• RIGHT

• LOWER

• UPPER

Which text function is used to convert a string of text so all characters are all initially capitalized?

• LEFT

• PROPER

• RIGHT

• LOWER

• UPPER