Prefix "www." to Website Address

kjxavier · #1 03-05-2012, 11:28 PM

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 · #2 03-05-2012, 11:59 PM

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

Code:

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
Creating Rules to block Senders by "Nickname" rather than email address	RavnResn	Outlook	1	05-24-2011 01:35 AM
Time limit on the use of "add e-mail address" add-in by Sperry	M777	Outlook	0	04-21-2011 06:39 AM
Find & Replace words with "/" prefix & suffix	tollanarama	Word	4	01-25-2011 02:19 AM
Change "From" Address in Gmail Account for Outlook	BigARC	Outlook	3	03-22-2010 08:00 PM