Excel macros are my new favorite thing, I lie they have been really useful for years and it is only lately I have started to blog the ones I use every day. Today’s task is getting a list of keywords ready to parse to code, by adding a comma to the end of a long spread sheet of values :)
A quick one about a new SEO project for John M Walsh. John is an Enterprise Architect & IT Adviser based in Belgium. Luckily the site is already Wordpress so a small spring clean on site and removal of some strange robots.txt should see this site indexed in less than 48 hours. Main keywords here will be Enterprise Architect & IT Adviser Belgium, a simple ask and one which I estimate will take a few weeks. Watch this space, oh and do check out the site johnmwalsh.com
Read More on
Enterprise Architect & IT Adviser Belgium – John M Walsh 
Excel is an excellent tool, pardon the half pun :) Automation is one of my favorite things about excel. Have you ever found yourself getting copy past blindness, adding hundreds if not thousands of fields to an excel sheet. Using this handy Macro you can save yourself some time and get back to the real work.
So here is the scenario, you have an Excel doc full of plain text links and you need to convert them to clickable links. Normally I would have to click on each cell and hit Enter, this can be very time consuming. Using a small macro you can automate this task. Check out how to save yourself time when using Excel.
Posted on 14 Feb 2012 ,
Be the first to Commentby Niall Flynn
in Random News Small Business SEO