Question

Which of the following functions in Excel that remove duplicate space and spaces at the start and end end of a text string

• A. LEFT
• B. MID
• C. TRIM
• D. LOWER

Answer 1

Answer:

C. TRIM

In Excel, the TRIM function is designed specifically to clean up your data by removing all leading and trailing spaces, as well as any "double spaces" between words, leaving only a single space between them.

How it breaks down

• Leading Spaces: Removes any spaces before the first character.

• Trailing Spaces: Removes any spaces after the last character.

• Extra Internal Spaces: Reduces multiple spaces between words to just one.