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.