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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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