How can we remove extra spaces from text formula?
You can also remove spaces using the Find/Replace feature in Excel. Click CTRL+F to open the Find dialog box, then click the Replace tab. Enter one space ” ” in the Find what: field and leave the Replace with: field empty to remove all spaces.
How to remove extra spaces in JSON?
string() removes spaces from JSON values
Double spaces are reduced to single spaces.