Adding "http://" to the front of a column of web URLs that start with www

**scottlin** · 08-15-2012, 11:05 AM

Hi guys and girls.

I have a database that has a column of website address / URL's and they are all formatted like www.somedomain.com

I need the to all be formatted http://www.somedomain.com

So i am wondering if there is a simple easy and fast way to add http:// to the beginning of every entry in the URL column rather than manually having to enter the http://?

Thank you very much in advance for any advise or guidance you can provide me.

Have a great day

Scott
Australia

**ChemistB** · 08-15-2012, 11:07 AM

Select the range, CNTRL H to bring up the find and replace box
Find www
Replace with http://www
Replace all
Does that work for you?

**scottlin** · 08-15-2012, 11:29 AM

Originally Posted by ChemistB

Select the range, CNTRL H to bring up the find and replace box
Find www
Replace with http://www
Replace all
Does that work for you?

That was very simple wasn't it

Thank you thank you thank you! That made complete sense and it worked.

Now I'm very very happy with that but if you want to go for double or nothing

Whilst that worked perfectly and brilliantly it exposed something i didn't realise....25% of the URL's don't have the www part and are just in the form of somedomain.com so i still need to add the http:// part at the front of about 25% of 182,000 URL's lol.

Not sure this is as easy but I'm totally prepared to be shown I'm very wrong and really hope you can.

Thank you ChemistB for that....an answer with in minutes and a simple solution, this place is awesome already and i appreciate your help very much

Cheers mate!

---------- Post added at 01:29 AM ---------- Previous post was at 01:28 AM ----------

I wont mark as solved just yet but once this part is answered or shown to be not possible I most certainly will.

Thanks

**ChemistB** · 08-15-2012, 11:36 AM

Let's say your data is in Column A starting in A1
Assuming you've already done the part with the Http
In B1
=IF(LEFT(A1,4)="http",A1, "http://www."&A1)
or if you want the http without the www
=IF(LEFT(A1,4)="http",A1, "http://"&A1)
dragged/copied down.
Then Copy Column B and Paste Special> Values into column A. Delete B
Does that work for you?

PS. Thanks for the Rep

**scottlin** · 08-15-2012, 12:03 PM

I'm now showing my total n00bness....I haven't been able to get that to work but not coz it doesn't but because i don't think i understand formulas and how they work or are entered properly. But I'm sure i can give this to a friend who will get it straight away which is what i will do tomorrow (2 am here) and then i will report back.

Thank you again for your help (I'm not going to ask more and waste your time when i don't even know what is clearly the basics) i really appreciate it and re the rep, the least i can do!

Cheers!

**ChemistB** · 08-15-2012, 12:07 PM

I'm not sure if Australia uses commas or semicolons between arguments. In the USA, it's commas so you'd need to adjust that. Let me know what's not working and I can talk you through it.

**scottlin** · 08-16-2012, 11:53 AM

ChemistB, thank you so much! I got my friend to show me how to put the formula in (i thought i was doing the same thing last night but clearly not) and it worked perfectly!

Very impressed! Thank you again, you saved me a lota work mate!

Thanks,

Scott