Insert text to the beginning of every Cell in a Column

1

2

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.

Mini John

Posted 2014-07-07T12:54:05.620

Reputation: 121

Answers

6

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.

root

Posted 2014-07-07T12:54:05.620

Reputation: 2 992

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) – Mini John – 2014-07-07T13:04:01.873

1Can 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 – 2014-07-07T13:13:41.400

Yeap, "paste only Values" does the trick! Thanks. – Mini John – 2014-07-07T13:16:22.293

Asked: 2014-07-07T12:54:05.620

Viewed: 43 316 times

Active: 2017-02-17T17:56:42.537