How to Append Text in Excel column

When you attach several worksheets, you are bringing one worksheet to another since the word append implies to add to. This might imply that you are merging many worksheets into one new worksheet or adding a worksheet or worksheets to an existing one.

Text can be appended using the following functions:

Append text using the Ampersand Operator:

The operator ampersand (&) is mostly used to combine multiple text strings into one.

Here's how you use it to add text to the first cell of every range. Assume you have the following list of names and wish to prefix each name with the designation Prof.

The steps to add a text before a text string in Excel are as follows:

In the column where you wish the transformed names to display, click on the first cell (B2).

Add the words Prof., a period, and an ampersand after the equal sign (=).

Choose the cell that contains the first name (A2).

Hit the Return key to exit.

You'll see that the word Prof. is put before the list's first name.

Using a formula, preface the names with text

It's time to duplicate this formula in the remaining column's cells. Just click twice on the fill handle (located at the bottom right of cell B2). As an alternative, you may accomplish the same result by dragging down the fill handle.

That's all; each name in column B should now have the prefix Prof. before it.

Append text using CONCATENATE Function:

You may add text to the beginning and end of the text string using the Excel function CONCATENATE.

The CONCATENATE function's general syntax is as follows:

=CONCATENATE(text1, [text2], …)

You wish to merge the sub strings text1, text2, etc. in this sentence.

Let's use the same dataset as before and use the CONCATENATE function:

In the column where you wish the transformed names to display, click on the first cell (B2).

Enter the equals symbol (=).

Enter the opening bracket (, then the function CONCATENATE.

Place the word Prof. in double quotes before adding a comma (,).

Choose the cell A2 that contains the first name.

Put a closing bracket there. Your formula should now read =CONCATENATE(Prof. ,A2) in our example.

You'll see that the word Prof. is put before the list's first name.

It's time to duplicate this formula in the remaining column's cells. Just click twice on the fill handle (located at the bottom right of cell B2). As an alternative, you may accomplish the same result by dragging down the fill handle.

That's all; the title Prof. should now appear in each of your cells in column B.

Append text using Flash Fill:

The function makes use of Excel's capacity for pattern recognition. In essence, it finds a pattern in your data and fills in the other cells of the column for you automatically using that pattern and append text.

The following describes how to use Flash Fill to add text to the first cell of every column.

In the column where you wish the transformed names to display, click on the first cell (B2).

Simply manually write Prof., then the first name on your list.

Repeatedly click on cell B2.

Click the Flash Fill button (located in the 'Data Tools' group) under the Data tab. As an alternative, you may simply hit CTRL+E (or Command+E on a Mac) on your keyboard. Select Flash Fill.

The remaining cells in the column will receive a copy of the same pattern as a result.

Did you learn about how to append text in an Excel file? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets and PowerPoint Slides.

You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.