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

Why is my number stored as text in Excel? Excel doesn’t convert numbers written in text into digits if you import data from another source because of the default setting.

Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.

You can subtract numbers in Microsoft Excel in a few different ways, depending on your data and formatting.