Excel 2007 : How to add the same text to multiple cells with preexisting text

Hello ,

Here is my issue:

I have a list of SKUs in Excel and I need to add one same word to 500 cells that have pre-existing text in the cells. See example below:

1) List of SKU's in cells:

34
35
39
55


2) text that needs to be added IN FRONT of every number:

DF

So the result would be:

DF34
DF35
DF39
etc.

How do I do that in a formula and not manually? I found another similar thread and I understand how to do it from the instructions there but the same text goes on the back and the result is: 34DF but I need it to be like: DF34.

I am using Office 2007 for mac.

Thank you for the help,
Chris

Thank you very much teylyn,

It worked! It was easy and painless.

Chris

Originally Posted by teylyn

Hi chris_ks

welcome to the forum. Without seeing your workbook layout, I suggest these steps using a temporary helper column

- to the right of the column with your SKUs, insert a new column, unless it is already an empty column.
- enter this formula into the first row of the new column

="DF"&A1

- If your SKUs are not in column A, change the A1 to the respective column letter.
- copy this forumula down to the row with the last SKU
- copy the whole column with the formula
- select the column with the SKUs and click Edit - Paste Special - Values
- finally, delete the helper column.

hth

Hi,

I just registered only to say thank you for this simple but amazing solution!