The Excel TEXT Function is used to convert numbers to text within a spreadsheet. Step 3. There are two formulas to add specified text to the beginning or end of all selected cells in Microsoft Excel.
Press Tab and Word will select the Quantity field.
Value is the numerical value that we need to convert to text. We can add the text values according to our preferences either by using the CONCATENATE function in excel or ampersand symbol. Use the Formula dialog box to create your formula. Formula TextValue format_text Where.