Commas are often used as thousand separators in numbers to make them easier to read. However, when working with numbers in Excel, it is sometimes necessary to convert them from text with commas to numeric values. This can be done using a few different methods.
One method is to use the FIND and REPLACE functions. The FIND function can be used to find the position of the comma in the text string, and the REPLACE function can then be used to replace the comma with nothing. The formula to do this is:
=REPLACE(A1,FIND(“,”,A1),1,””)