Add Same in each cell in column

  • Thread starter Thread starter S1L1Y1
  • Start date Start date
S

S1L1Y1

I am trying to add the same words to the beginning of each cell in a column
like for example the following ""abc.com/catalog/" to the beginning of the
cell.
Sol
 
Say we have data in column A from A1 thru A100. Say the data is text and not
formulas. In B1 enter:

="abc.com/catalog/" & A1 and copy down

then copy column B and paste/special/values back onto column A
then clear column B


If column A contains formulas, the approach is much simplier. Using
Find/Replace, replace:
=
with
="abc.com/catalog/" &
 
Back
Top