Question

What function removes extra spaces at the beginning and end of a string? A) Trim() B) Substring() C) Replace() D) Concat()

Answer 1

The function which removes extra spaces at the beginning and end of a string is Trim function.

The correct answer choice is option A.

What function removes extra spaces at the beginning and end of a string?

The TRIM function is used majorly in programming and data processing to eliminate unnecessary spaces. TRIM automatically strips space at the start and end of a given string and leaves just one space between all words inside the string.

It also eliminate extra spaces caused by empty cells.

Hence, Trim function is known for eliminating spaces.