Prefix "www." to Website Address

[kjxavier]

Hi!!

I have some websites listed like:


ranibennur.co.in rangia.in




and i have them more in Nos. I would like to prefix them with www.

so that it becomes

www.ranibennur.co.in
www.rangia.in

your help will be highly appreciated .....

[jolivanes]

If the Websites are in Column C, starting at C1, try

Sub TryThis()
    With Range("C1:C" & Cells(Rows.Count, "C").End(xlUp).Row)
        .Value = Evaluate("""www.""&" & .Address)
    End With
End Sub