Learn how to remove formula in Excel and keep the text. Use Paste Special option to delete formulas without removing values in Excel.

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