How to strip out domain from cell in excel

I use this formula all the time when I have a list of page URL’s when I only want the domain name.


If you want the domain without the trailing slash its:


If you want just




htaccess file to redirect non www. and redirect index.html

The following code is what I use in the .htaccess file to add the www. onto the domain and redirect /index.html to the domain.

RewriteEngine On
Options +FollowSymLinks

RewriteCond %{HTTP_HOST} !^ [NC] RewriteRule ^(.*)$$1 [L,R=301]

RewriteCond %{THE_REQUEST} ^.*/index.html
RewriteRule ^(.*)index.html$ http://%{HTTP_HOST}/$1 [R=301,L]

Web Design Projects

New website: Simones Housekeeping Service

Started working on putting together a website for Simones Housekeeping Service website. Already got some content on there and the website should be live and finished in the next two weeks.

Watch this space for how the website develops. Will be styling up the website as requested and will be designing the website myself.

To view Simones Bespoke Housekeeping Service website visit

Rants, Thoughts & Opinions

Manchester Bars I Will No Longer Go In

Waxy O’Connors – Printworks – £5 for a bottle of Magners with a pint of ice.

Odd – NQ – £3.90 for a lager shandy. When I questioned the barmaid and manager they didnt give a toss.

Simple NQ – They have cameras in smoke alarms in the gents toilets.

Hula NQ – £2 to get in a cocktail bar… dream on.

Noho NQ – On weekends you have to take your jacket off before you are allowed past the bouncers. You are also not allowed to carry bottled water into the premises even if its just in your bag.

Blackdog Ballroom NQ – £4.70 for a bottle of Rekorderlig (as of 1st July 2012). This was an overpriced £4.50 just 4 months ago and is creeping up and up. Blackdog is getting too big for its boots. You used to be North for christs sake.