I have created a video to demonstrate how you could extract a country listing from the internet in just a few minutes. In the video, I demonstrate how I could delete the blank rows between the country in less than a minute, and using the replace all function and the wildcard (*) to remove all the unwanted extras in just another minute. Click on the video below to watch:

[kml_flashembed publishmethod=”static” fversion=”8.0.0″ movie=”https://www.excel-course.com/wp-content/uploads/2012/02/replace-all-with-wildcard.swf” width=”600″ height=”450″ targetclass=”flashmovie” play=”true” align=”center” menu=”true” quality=”best” allowfullscreen=”true”]

Get Adobe Flash player


Leave a Reply