For example, Suppose cell A1 has the phrase “Product Code:” and cell B1 contains the product code as a numeric value. You can concatenate them by using the TEXT function in the manner shown below: =TEXT(B1, "Product Code: ")
For example, Suppose cell A1 has the phrase “Product Code:” and cell B1 contains the product code as a numeric value. You can concatenate them by using the TEXT function in the manner shown below: =TEXT(B1, "Product Code: ")