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

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. Required fields are marked *

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