Nowhere in certain texts

Prepend cells with certain texts in Excel

Jason Swett

I want to take some of my cells that look like this:

and transform it into the following:

Is there an easy way to do that?

4 answers to the question


Use the CONCATENATE formula. The following example assumes your first value is in cell A1.

With the above data in cells A1-A5, you can get the result you want by typing the following in cell B1:

and copy it into B2-B5


I think using the chaining feature requires unnecessary typing. Just use the ampersand to concatenate values:

I find it easier.

You can copy the following to the first column of the next and drag the lower left corner of that cell down: