Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

up vote 4 down vote accepted

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

=CONCATENATE("0049",C1)

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 at 13:04
1  
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 at 13:13
    
Yeap, "paste only Values" does the trick! Thanks. –  The Mini John Jul 7 at 13:16

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.