Add Text to Cell in Excel

You can add text to a cell using ampersand “&”. First, find a cell you want to add text to. Next, enter the text or a reference to a cell with text or a number. If you do it for a number it will be formatted to text in the cell with the formula.

You can add text at the beginning or at the end of a cell.

Add text to all cells in the column

If you have multiple cells in a column, you can use autofill and the text will be added to all of them.

If you want to and spaces between the cells use the following formula.

Add text based on cell color

In order to check cell color, we have to use VBA. This is the example we are going to use.

Press Alt + F11 to open the VBA editor and use this procedure to check what indexes have the colors we use in our example. We will do it for cells A1 and A2.

Run this code.

This example returns the following values: 14 and 3. Now let’s create a function that will name color and add it to the cell.

Create a new module for the current document and enter this code.

Now, the new function called NameColor appeared. This is the result.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.

Posted in vba