Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to find a way to insert text in to every Cell in a specific Column.

e.g. Column C has 50 rows: I need to insert 0049 to the beginning of every Cell.

I didn't had any luck finding/creating a formula for this.

Help is much appreciated.

share|improve this question
up vote 4 down vote accepted

Create a blank Column (D) and use "CONCATENATE":


Drag that down for each adjacent cell in Column C and it will add 0049 as a prefix.

share|improve this answer
Thanks! I just found that and tried to replace the column with the concatenated one. Which isn't working because one part of the equation is missing.. Is there a way to instantly replace the values in a cell ? (So I have in Column C the right values) – The Mini John Jul 7 '14 at 13:04
Can you be a little more descriptive? Do you need to convert forumlas to their values? When I need to do this, I copy the entire column and do a Paste Special into a new column, and choose to paste only the Values. – root Jul 7 '14 at 13:13
Yeap, "paste only Values" does the trick! Thanks. – The Mini John Jul 7 '14 at 13:16

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .