How do you automatically add www. in front of every single field in a column?

[sjeff]

The fields in my column are a list of websites, however they are missing the "www." in them. So I want to know what formula will automatically add the "www." in front of the values of each of the fields in the column?

 

[Michael M]

Insert a new column
Assuming your data is in column "A"
in the new column use

="www."& A1

copy down as required

You can then copy / Paste Special / Values over the formula and delete the original column.

 

[sjeff]

Thank you

 

[Michael M]

Pleasure...