Replace value for each cell in a row at once

  • Thread starter Thread starter Terence
  • Start date Start date
T

Terence

Hi,

I have a worksheet which has a few thousands of rows. I
want to add a character "Z" as prefix in each cell before
each string in column A (except the first row since it is
the header row). What formula should I use in order to do
this task?
Thanks in advance.

Terence
 
In cell B2 enter the formula
concatenate ("Z", A2)

Copy this formula and paste it down in column B to as many
rows as you want.

This of course does not change the values in column A
physically. If that is what you wanted to do, then use
the following additional steps:
(a) copy B2:Bn where n = last row in column B where you
have your data
(b) paste special, values in cell A2.
(c) delete column B

This will change all values in column A. Beware, if coumn
A contained formulas then those will be overwritten.
 
Terence said:
Hi,

I have a worksheet which has a few thousands of rows. I
want to add a character "Z" as prefix in each cell before
each string in column A (except the first row since it is
the header row). What formula should I use in order to do
this task?
Thanks in advance.

Terence
Click to expand...

Assuming all your cells in column A (except A1) contain strings that you
want prefixed, in B2 you could put
="Z"&A2
and copy this down as far as required in column B.
If this is meant to be a permanent change, you can then copy these cells and
Paste Special > Values over column A, and then column B can be deleted.
 
Back
Top