How to add different text to multiple cells in Microsoft Excel

Adding text to multiple cells in Excel is a useful feature that can save time and effort when working with large amounts of data. Adding a text to multiple cells is a common task in excel such as adding a prefix or suffix to a list of names or values. This feature is particularly useful when working with data sets that require consistency in formatting, such as customer lists or inventory records.

In this tutorial we will learn how to add a text to multiple cells in Microsoft Excel.We can add text to multiple cells by adding the text into the first cell using the CONCATENATE function or Built-in Flash Fill feature in Microsoft Excel.

In the current dataset,we have marks of a student and subject code of each mark in another column. We will add the subject code to the obtained marks.

Method 1 – Using  the CONCATENATE Function to Add Different Text to Multiple Cells

Step 1 – Select a Blank Cell

  • Select a Blank targeted cell where you want to print the text string after adding text.

Step 2 – Place an Equals Sign

  • Place an Equals sign ( = ) in the targeted blank cell.

Step 3 – Use the CONCATENATE Function

  • The CONCATENATE function in Excel is used to join two or more text strings into one string. The function can be used to combine text from different cells or to combine text with other characters, such as commas or spaces.
  • The syntax for CONCATENATE function will be 

                                         CONCATENATE(B2,” – “,A2)

  • Where the first argument i.e.B2 is the address of the cell containing the text to be added and the second argument i.e. “ – “ is a separator.
  • The third argument i.e.A2 is the address of the cell in which the text is to be added.

Step 4 – Press the Enter Key

  • Press the Enter Key to add the text to the cell.

Step 5 – Apply the CONCATENATE Function to All the Data 

  • Apply the CONCATENATE function to all the data using the “Handle Select” and “Drag and Drop” method.

Method 2 – Adding Different Text to multiple Cells using Flash Fill

Step 1 – Enter the Text in the First Cell

  • Add the text in the first cell manually so that Fill Feature can recognize the pattern.

Step 2 – Press CTRL + E keys

  • Press the Flash Fill shortcut keys i.e. CTRL + E,varied text for each cell will be added automatically.

Leave a Comment