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

2] Remove dashes in Excel by using the Find and Replace method This method does not work if a particular format is already applied to your cells, say SSN (Social Security Number) format.

Need a formula for your Excel spreadsheet in a flash? Try ChatGPT. In this guide, we'll show you how to write Excel formulas using ChatGPT.