Select the cells you want to change
Press Ctrl + H
In Find what, type ,
Leave Replace with blank
Click Replace All
If the commas are part of a number format, select the cells
Press Ctrl + 1
Go to Number
Choose Number or General
Uncheck Use 1000 Separator (,)
Click OK
If the commas are in text, use the SUBSTITUTE formula: =SUBSTITUTE(A1,”,”,””)
Fill the formula down if needed
Copy the results
Paste Special as Values if you want to keep the cleaned text