Commas are sometimes used as thousand separators in numbers to make them simpler to learn. Nonetheless, when working with numbers in Excel, it’s typically essential to convert them from textual content with commas to numeric values. This may be finished utilizing a couple of completely different strategies.
One technique is to make use of the FIND and REPLACE capabilities. The FIND operate can be utilized to seek out the place of the comma within the textual content string, and the REPLACE operate can then be used to interchange the comma with nothing. The formulation to do that is:
=REPLACE(A1,FIND(“,”,A1),1,””)
