Which of the following functions in MS Excel 365 removes irregular spaces leaving one space between each value?

Correct option is D

• The TRIM function in MS Excel is used to remove all extra spaces from a text string, leaving only a single space between words. It is particularly useful for cleaning up text data that contains leading, trailing, or multiple spaces.
• Example:

  excel
  =TRIM("  Hello   World  ")  

  Output: "Hello World"

Additional Information:

• AVERAGE: Calculates the arithmetic mean of a range of numbers.
• SUM: Adds up numbers in a range.
• VLOOKUP: Looks up a value in the first column of a range and returns a value in the same row from another column.