You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

Finally, parentheses are used in Excel to nest functions. In this example, the SUM function is nested within the IFERROR function so that if the result returns an error, a blank cell is displayed: ...

You should use Excel’s auto-complete feature to avoid such typos. You also need to factor in parentheses, as they will dictate the order of operations in your formulas.