Excel Formula removing commas and special characters

[ajcarlos18]

What is the excel formula to be used in the following strings? I need to remove spaces and commas, etc. Ex. CC1994, 2 - it should be CC19942

 

[anglais428]

If it is just spaces and commas you could use =SUBSTITUTE(SUBSTITUTE(A1,",","")," ","")
(change A1 to the cell that houses your data)

 

[ajcarlos18]

If it is just spaces and commas you could use =SUBSTITUTE(SUBSTITUTE(A1,",","")," ","")
(change A1 to the cell that houses your data)

Thank you very much.