Question: How to remove spaces?

Solution:

By multiplying with 1, the text string is converted to a number.
Convert text to integer in formula

=SUBSTITUTE(text;old_text; new_text; [instance_num])
Replaces existing text with new text in a text string