Autofill data in cell with other existing data.

S

Steen Lautrup

I have a range of cells, a column, with a lot of domains. for instance;
svanholmelektro.dk,
I need www. first in all of these.
 
F

FSt1

hi
you can use a helper column and a formula.
lets say your domain data is in column a. add a blank column B. in column b...
="www." & A2
copy down.
copy column b and pastespecial values. to turn the formula in to hard data.
delete column a.

Regards
FSt1
 
Top