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

3] Replace dashes in Excel by using the SUBSTITUTE function The SUBSTITUTE function in Excel is used to replace a particular text with another text. Here, we will show you how to use the ...