Add specified text to the beginning end of all cells with Kutools for Excel. Now hit enter to complete the formula along with our own text values. Click the Kutools Text Add Text.
Click the Kutools Text Add Text.
The quotes tell Excel its dealing with text and by text we mean any character including numbers spaces and punctuation. In Add Text dialog box enter the text you need to add in the Text box. Put your required formula in a cell preferably select this cell just behind your text box. Click on the cell in which you had written your formula.