How To Remove HTML tags from an excel spreadsheet

13 May 2009 Categories: Do It Yourself

I thought I would share this easy solution for removing specific html tags from excel spreadsheets:

1. Highlite the cells that contain the html tag you would like to remove.
2. Open the Find and Replace window (CTR+H)
3. Enter <*> in the “Find What:” field
4. Leave the “Replace with:” field blank
5. Click the Replace All button and all HTML tags will be removed

If you want to just remove a specific html tag, say all image tags (<img>), you would enter <img*> in the “Find What:” field. This would leave all other HTML tags except images intact.

Here are some other common HTML tags you may want to remove:
1. <*div*> removes all div tags
2. <*href*> removes all links

Read the full article 2 Comments

How To Create A Favorites Icon (favicon.ico)

25 March 2008 Categories: Do It Yourself

You may have noticed a small image in the URL bar of your browser when visiting certain websites. This image also appears in tabbed browsing and favoritesfavicon menus. You may have even noticed file not found errors in your web logs for a file named favicon.ico. This file is called a favorites icon, and it is meant to be a visual way of quickly identifying a site in a list. It is really easy to create and is a quick way to improve your site’s branding.

In the image to the right, you’ll see a drop down menu from a browser with sites that have Favorite Icons. Google has a small “G” while Red Bull has a small bull. If the browser you are using right now to read this uses favicons, you should see an acorn image.

Lets get started. First, you need an image. It should be square and can be any size to start (it will shrink down to 16 x 16 later). It should be very simple since this image is going to be very small. The more complex the image is, the less likely visitors will be able to distinguish what it is.

Now take your image and go over to Favicon Generator. Simply follow the steps there, upload the resulting favicon.ico file to your root directory and you’re done! Note: They recommend you put a line of html code in the head section of every page to tell browsers there is favicon file but I’ve found it isn’t necessary, some browsers will eventually find it on their own. If you can make the change easily, it will definitely help speed up the display of your icon (Simply add <link rel=”shortcut icon” href=”/favicon.ico” > in the head section of your site.

Read the full article 0 Comments