Use Find and Replace
Press Ctrl + H
In Find what, type a space
Leave Replace with blank
Click Replace All
Use TRIM to remove extra spaces from text
In a new cell, enter =TRIM(A1)
Copy the formula down
Copy the cleaned cells
Paste Special as Values
Use SUBSTITUTE to remove all spaces
Enter =SUBSTITUTE(A1,” “,””)
Fill down as needed
Use Text to Columns for fixed spacing issues
Select the column
Go to Data
Click Text to Columns
Choose Delimited
Set the delimiter as space if needed
Finish the wizard
Remove leading or trailing spaces with TRIM
Remove nonbreaking spaces with =SUBSTITUTE(A1,CHAR(160),””)
Combine with TRIM if needed
Use Flash Fill for pattern-based cleanup
Enter the desired result in the next column
Press Ctrl + E