Question

which function removed extra space from string in calc ​

Answer 1

Answer:

Syntax: TRIM(text)

This function removes extra spaces from strings.

Hope it helps you...

Answer 2

Answer:

TRIM function

You use the TRIM function in Excel removes extra spaces from text. It deletes all leading, trailing and in-between spaces except for a single space character between words. Where text is a cell that you want to remove excess spaces from.

Explanation:

Hope this helps you..