Add specified text to the beginning & end of all cells with formulas

http://www.extendoffice.com/documents/excel/670-excel-add-text-to-beginning-end-of-cell.html#formula

There are two formulas to add specified text to the beginning or end of all selected cells in Microsoft Excel.

Method 1: & formula

Enter the =”Class A: “&A1 in Cell E1, and copy this formula to other cells with dragging the bottom right corner of the Cell E1.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.