Add common prefix to all cells in Excel

Question

I have a column with some text in each cell.
I want to add some text, for example "X", at the start of all cells. For example:

A             B
-----  >>>>  ----
1            X1
2            X2
3            X3

What is the easiest way to do this?

Answer 1

Using the Concatenate Function in Excel, you can add a prefix.
Another option for adding a prefix or suffix to a set of cells in Microsoft Excel is to use the "Concatenate" function.

To use the Concatenate function to add the prefix (Dr.), type =Concatenate("Dr. ",A4) and press the enter key on your computer's keyboard.