How to add text to multiple cells in excel

There may be instances where you need to add the same text to all cells in a column.

How to add text in excel formula

How to add text to the end of a cell in excel

How to insert file in excel cell

How to add text to the beginning or end of all cells in excel

How to insert word file in excel as icon

You might need to add a particular title before names in a list, or a particular symbol at the end of the text in every cell.

The good thing is you don’t need to do this manually.

Excel provides some really simple ways in which you can add text to the beginning and/ or end of the text in a range of cells.

In this tutorial we will see 4 ways to do this:

• Using the ampersand operator (&)
• Using the CONCATENATE function
• Using the Flash Fill feature
• Using VBA

So let’s get started!

Method 1: Using the ampersand Operator

An ampersand (&) can be used to easily combine text strings in Excel.

Let’s see how you use it to add text at the beginning or end or both in Excel.

Using the ampersand Operator to Add Text to the Beginning of all Cells

The ampersand (&) is an operator that is mainly used to join several text strings into one.

Here’s how you can use it to add text to the beginning of all cells in a range.

Let us assume you have the following list of names and

how to insert text in excel table

how to insert text in excel file