Select the cells with the numbers
Press Ctrl + 1 to open Format Cells
Go to the Number tab
Select Number, General, or Custom
Uncheck Use 1000 Separator (,)
Click OK
To remove commas from text-formatted numbers, use Find and Replace
Press Ctrl + H
In Find what, type ,
Leave Replace with blank
Click Replace All
To remove commas with a formula, use =SUBSTITUTE(A1,”,”,””)
Fill the formula down as needed
Copy the results and paste as values if needed