how to welding tubular Consequently, the above formula refers to cells that contains numbers and text strings and adds the values to return the #VALUE! error. The error is since the expression performs an arithmetic operation that works only with numbers. But some input values, in this case, are