How to SUM Or Add Cells Containing Text & Numbers With SUBSTITUTE & SUM Functions in Excel.

How to SUM Or Add Cells Containing Text & Numbers With SUBSTITUTE & SUM Functions in Excel.
Using SUBSTITUTE Function to SUM Cells with Text and Numbers
The formula that we used here uses two Excel functions, the SUBSTITUTE function, and the SUM function. Firstly, the formula separates the text from the numeric values using the SUBSTITUTE function, and secondly, adds them up using the SUM function.