How to properly open a .csv file in Excel 2010?

Most of the time, opening a .csv file in Excel 2010 does not pose any problems, but sometimes it looks something like in the screenshot here.

By default, the data fields in a .csv file are separated via a “,” (comma), but when they are separated by a “;” or a “|” or another character, it displays the contents within the A column of the spreadsheet.

There are two options:

1. Select the entire A column, go to Data->Text to columns->Choose the delimited option->Select your delimiter (“;”, or “|”, or “,”, etc.) and finalize the process. Most of the  time this method works.

2. This other method will ensure that any .csv files with a specific delimiter opened in Excel 2010 will be displayed properly. You can change this at any time if you change your mind and you want to keep the default “,” delimiter.
In Windows 7 go to Control Panel->Region and Language->Additional Settings->List separator. In here just replace the “,” with your desired character, usually “|”. Click OK and you’re set.

Be advised that the second option might create further problems as it also changes how other problems read delimiters and it definitely changes how Excel functions are written. It is recommended you change it back to “,” after you’re done with the .csv file.

How can I separate the first name from the middle names in Excel?

You can either use the text-to-columns function in Excel, or for better flexibility in separating the first name from the middle names, use the following functions:

Assume you have the first and middle name in the column A.

Then in column B display the first name: =IFERROR((LEFT(A1(FIND(” “,A1)-1))),A1)

In column C display the middle name(s): =IF(ISERROR(RIGHT(A1,(LEN(A1)-FIND(” “,A1)))),””,RIGHT(A1,(LEN(A1)-FIND(” “,A1))))

 

How to prevent shinsplints?

I have recently started running in order to train for a 10 km race. Maybe I did not warm up enough, maybe I was too out of shape, maybe I was wearing the wrong shoes, maybe I should have start running a lesser distance in the beginning, I don’t know. The fact is that I have shinsplints which were quite paintful. The doctor told me not to run anymore, to do other sports as running puts a lots of stress on one’s feet.I agree that it puts a lot of stress on one’s feet, especially if running on concrete, but to stop running? Well, that’s bullocks!Here are some easy exercises that I have found that you could start doing in order to strengthen the muscles attached to the shinbone and prevent shinsplints from happening to you.

How to add a Facebook Like button on my website?

Simply go to developers.facebook.com/docs/reference/plugins/like and follow the very intuitive and user friendly Like button “wizzard”. After selecting your option it will generate a code similar to the one below:<iframe src=”http://www.facebook.com/plugins/like.php?href=www.test.com&amp;layout=button_count&amp;show_faces=false&amp;width=450&amp;action=like&amp;colorscheme=light&amp;height=21” scrolling=”no” frameborder=”0″ style=”border:none; overflow:hidden; width:450px; height:21px;” allowTransparency=”true”></iframe>The only problem is that this will enable visitors to just Like the URL (usually the link to your homepage) that you have entered in the “wizzard”. If you want the Like button to reflect the URL of a particular page that they are on, then you have to do a bit of programming.It’s not hard, here is how you do it in PHP:Replace the URL which follows after “href” (in this case www.test.com) with the following code:<?php echo urlencode(“http://”.$_SERVER[“SERVER_NAME”].$_SERVER[“REQUEST_URI“]); ?>Copy/paste it in the file you wish to display your Facebook Like button. Make sure it is a php file.

How to find out what is your personality type?

Quickly select one of the nine images below to find out what is your personality type.Apparently these images were conceived by a psychologist and tested on a lot of people. Based on the received feedback, these images have been improved several times and re-tested until they became very accurate in determining someone’s personality type.

Here are the characteristics of each of the above images:

Continue reading “How to find out what is your personality type?”

How to delete a folder via SSH?

If you want to delete or remove an entire folder and its contents from your hosting server, you will usually do it via an ftp client like FileZilla. The problem arises if the the folder has a lot of subfolders and a lot of content, overall. It could take hours, while your FTP connection keeps droping.The easiest way is to delete the entire folder via SSH.Here are the simple steps to follow:1. Login into your server via your desired SSH client (ex: PuTTY)2. Navigate to the root of the folder you want to remove3. Type: rm -r -f folder_you_want_to_deleteDone!

How to install Magento on Netfirms?

After a week of daily trial and error, I’ve almost given up with installing Magento onto Netfirms’ servers. I’ve tried installing using the downloader and the full realease with and without first installing the sample data. Nothing worked and I’m sure quite a few of you found yourself at the edge of frustration.There was another option left and this one seemed to work. I was going to install it via SSH. My optimism quickly failed as the “wget” and “./pear” functions were not allowed by Netfirms. I contacted Netfirms support to ask for more freedom via SSH so I can complete my Magento installation. Here was part of their reply:”Thank you for your inquiry.Regretfully, Magento application will not work properly on our shared server as it requires huge amount of resources to run it. We suggest signing up with our VPS hosting, Magento application will work on our VPS server.”Well, I wasn’t going to cough up ~$35 a month for that. I actually purchased another hosting plan with GoDaddy, but I haven’t been able to install it there yet either.Anyhow, the idea of not being able to install Magento onto Netfirms still haunted me. I gave it one last try and this one worked so here it is, step-by-step:(the solution is part of a paid service. Please contact us to purchase all the instructions)1.2.3.4.5.6. Go to www.yourdomain.com/magento/install/ and complete the installation wizard.Done! If you’re running into error pages with the installation wizard, be persistent and refresh the page and you’ll get to the end.Note: Magento does run a bit slow on Netfirms, but it runs.

How to use scented geraniums?

What are the most important product obtained from scented geraniums? Essential Geranium Oil – very expensive, very fragrant and intense used in perfumes industry to make perfumes, syntetic rose oil or fragrancing bath or body oils. Second usage is for decorative purposes: scented geraniums (aka scented pelargoniums) ennobles any garden with their exotic foliage, whether are planted in flower beds, hanging baskets or flower pots and their dried scented leaves with different shapes or textures are very appreciated in sachets and potpourri-es.What else can do with fresh leaves or flowers? If you know how to fit their taste and essences into your favorite recipes, you will appreciate their flavors in different dishes. Why is it a fragrant adventure to use their leaves in cooking? Because their diverse flavors: rose, lemon-rose, orange, apple, coconut, apricot, nutmeg, oak or champagne add an unexpected and mysterious touch to your homemade scented sugar, jelly, tea cake and/or syrup.

How to export/import your links from/to WordPress?

Forget about troublesome plugins and database queries or any other cumbersome methods.Simply add wp-links-opml.php at the end of your blog url. This will display the contents of an OPML file which contains your links/ blogroll info.To import the file just go to Settings ->Tools-> Import -> Blogroll and paste the link into the required field.Note: Categories are not transfered. All links are imported into one specified category.

How is AAfter.com web search engine beneficial?

AAfter.com is a high privacyweb search engine like I’ve never seen before. In one little simple tool it combines quite a few features. Some of my favorites are:1) Cash-back on lowest online prices – In these hard times, this feature definitely comes in handy. If you order a product online. Here’s how it works. Any product found on AAfter has a percentage of the product’s price coming back to you as cash if you order it though the site.2) Homework made easier – Simply type in your math, history or physics question and AAfter will give you back links to wikis, youtube, eHow and many other sites that will provide answers to your questions. Have any real life questions? AAfter can help you answer those too.3) Background check someone – Have you ever wanted to Background check your date or nanny? Well just simply enter their name in the search box and you should be getting back links related to them.Intrigued? Give it a try.

How to get rid of the SKU011.cab error?

If you have Word 2003 installed, you might have came across this error. Sometimes it is just annoying to have it keep popping up, but sometimes the Word documents won’t even open because if it. The easier way to get rid of it is to insert the Office 2003 CD and have Windows install the needed files from it. What happens if you don’t have it though? Well, the process is quite simple and does not require a system restart.Go to Start-> and type REGEDIT. Press enter and browse to:HKEY_LOCAL_MACHINE -> Software -> Microsoft -> Office -> 11.0 -> DeliveryUnder delivery you should see the following key 90000409-6000-11D3-8CFE-0150048383C9Click on it and on the right side of the screen right click on the CDCache key and select Modify (in bold).Type 0 as the new value and click enter. This should now take care of your error.Cheers!

How can you get Dragon Naturally Speaking 10 software at a disocunted price?

Dragon Naturally Speaking is the best speech recognition software in the world. You can now sit down in your chair, never touch your keyboard and dictate your text and control your computer by giving it voice commands.Check out a fellow postie’s video and blog article about this software:

Dragon Naturally Speaking 10 Basic with Discount Coupon Code“Hello my name is Brett Bumeter and I write about Dragon Naturally Speaking at Softduit.com (Tip if you are looking for the details on the coupon codes scroll to the bottom of this article). I wanted to share this video with you showing a fellow blogger named Drew who is using Dragon NaturallySpeaking 10 for the first time. There are some interesting things that you will see in this video that I wanted to point out to help you get a sense of how Dragon NaturallySpeaking works and how it could potentially work for you.I think it’s important to see Dragon NaturallySpeaking, when people are using it and videos definitely help show you how well the software works these days. It’s extremely fast and can help you to type at 150 words per minute. You can see this in the demonstration that Drew has created as he is basically talking at a relatively normal speed. You will notice that he tends to look with his eyes to the right and up just a little bit.I mention this not because Drew is looking in some strange direction, but instead because Dragon NaturallySpeaking does use your brain in a slightly different way than what you may be used to. You have to think of the words you will say in your head and then speak it out loud. That’s a little different than when you think of a composition and type it out with your fingers or even more different than when you attempt to write with your hands using a pen and paper. All three activities use different sections of our brains.There used to be a time a decade ago when using Dragon NaturallySpeaking was more difficult because it would take a significant amounts of time to train the software. These days, the software can be trained in as little as seven minutes. The out-of- the-box experience with Dragon NaturallySpeaking 10 is flat-out amazing. That said, it will take you a little bit of time to train your brain or compose messages or articles or e-mails by speaking them out loud.You can type 150 words a minute using Dragon NaturallySpeaking and that’s typically 2 to 3 times faster than your average person can type. 2 to 3 times faster can save you a great deal of time and a great deal of money. This can enable you to spend more time with your family or be more productive at work and get more done and possibly a promotion or raise. Possibly the biggest benefit that you can experience is just staying on top of your workload with less effort.If you consider also that Drew is looking off to the right a little bit as he’s composing, I will share with you a hidden benefit of Dragon NaturallySpeaking. When you use Dragon NaturallySpeaking, you are not locked into a position physically, where you have to stare at your computer monitor all of the time. When you don’t have the light on your computer screen glaring in your face all the time, you experience a great deal less eye strain. The muscles in your eyes can relax more, as you look around the room and change your focal point. You would be amazed at how much extra energy this will give you as your eyes, and the muscles in your eyes don’t get worn out as fast as they would if you sit at a computer and type all day long.We often associate sore hands and fingers and wrists with typing, but typing also creates very sore eyes and can even lead to migraine headaches. Plus, it basically just makes you tired sitting in front of your computer. Using Dragon NaturallySpeaking, you can save a great deal of time and effort and keep your energy level high, because you’re not wearing out your eyes. With a wireless microphone headset like the one I’m using, you can even pace around your desk or exercise on a treadmill or bike machine while you write your emails!Best regards,Brett Bumeterwww.softduit.comPS I wrote this article with Dragon NaturallySpeaking 10 preferred. It took me about five minutes to write the words above, which are proximally 670 in length. That’s about 130 words per minute typing, and it only took me another minute or two to edit, which is still approximately 95 words per minute with editing included!Dragon Naturally Speaking 10 Discount Coupon Code Details. Use this coupon code to get 25% off either Dragon Naturally Speaking 10 Preferred or Dragon Naturally Speaking 10 Basic.DNSMSBGThe code only works when you click on one of the links in this article or the clickable image in this article! The discount enables you to save $25 – $50 off the price.”So how can you get 25% off Dragon NaturallySpeaking 10 Preferred? Nuance is allowing us to offer our readers a 25% Discount Coupon CODE Exclusive for Dragon Naturally Speaking, but you must click the image above and use this code (DNSMSBG) Together. Code will not work from other sources.If you are a Mac user you can get 10% off MacSpeech Dictate and start taking advantage of it.Don’t forget, click on the following link and Save 25% on Dragon Naturally Speaking with Coupon Code

How to dispose of cooking oil?

I recently took part of a debate where the disposal of cooking oil was the main topic. It would not be advise to throw it down the drain because over time it could congeal and provide you with a major clog.If you have large quantities of cooking oil, take it to an oil disposal center. They will use it as an ingredient for the cow’s food and so forth or it will be turned into bio-diesel.Some of the other ideas I’ve heard:- put it in cans or jars and throw it with your garbage- freeze it and toss it out- save it and use it to light fires or barbeques in winter- add birdseed to it and feed it to the birds

How to create a hospital tank? (fish aquarium)

Select a tank of about 38 liters and fill it with unchlorinated water. Fill two 10 liters containers with water similar to that in your fish tank. Now move the fish to the first container using a net. Gradually add salt in the proper proportion to the water for 10 minutes. Then shift the fish to the next container and let it stay there for about 45 minutes. After 20 minutes add salt in the same proportion to the water in the container holding the fish. Now, move the fish to the hospital tank and change the water daily.Shift the fish to the main tank only after it recovers completely.

How to print zno files?

If you have not heard of zno files, then you might have heard of Zinio Reader. If you have not heard of Zinio reader, I will tell you right now. Zinio reader is a piece of free software that lets you view digital books and digital magazine. The format of these books and magazines is the mentioned “zno”.The reader is nice in the digital sense because it lets you purchase digital versions of many of your desired magazines and also books. What’s the advantage of purchasing a digital version? The main advantage is that is is cheaper, sometimes half the price or more. What is the disadvantage? The main disadvantage is that you cannot print many of them.The people that have tried might had noticed that the papers that come out of the printer are all grayed out and the content is ineligible. So how do you go around this? Well there is a way, but it has a downside. The downside is that you get a transparent, gray watermark across the middle of the page, but it can be easily ignored. So, if the watermark is no problem for you, here is what you do:1. Open the Zinio reader with the desired book or magazine2. Press the print button and select Adobe PDF (you have to have Adobe Acrobat installed prior to this step)3. Choose the pages you want to print and press OK4. Zinio will output every chosen page to a single pdf file which would be more convenient to have in a single pdf, right? For that, open Adobe Acrobat and select File -> Create PDF -> From Multiple Files. and choose all those files in numerical order5. You will have all the desired pages from Zinio in a single pdf file and as you can see you will also have the dreaded watermark on every page.6. Unfortunately you cannot print these yet. The pages will still be grayed out if you try to print them. What you need to do is to just print them again to Adobe PDF7. Now you can safely print them (try to ignore the watermark).

How to X-ray an egg?

…without putting it in the x-ray machine. Well, you take a normal egg and hold it over an open flame so it forms ashes on its shell. When it is all covered by ashes (totally black), just drop it in a bowl of cold water. The ashes will dissolve and you will be able to see the insides of the egg, i.e. x-ray the egg.For better details, you can watch the following video:

How are waves different from tides?

Waves are caused by wind, while tides are the regular rise and fall of the ocean’s surface caused by the gravitational pull of the Sun and the Moon on the water that is in the ocean. Waves are formed when winds blow over the surface of the ocean. Stronger winds create larger waves. The water in a wave normally moves in circles. As a wave approaches the land it is slowed down by the rising slope of the seabed, but it is the bottom portion of the wave that is slowed down. The top part of the wave keeps moving and collapses on to the shore as a breaker.

How to get a $51 room per night at Excalibur, Las Vegas?

Did you always want to go to Las Vegas and stay at a fabulous hotel on the Strip? I bet you did, but it always seamed too expensive, right? Well, this summer you can get your chance. Hotel Excalibur (the one with the castle theme) is offering an incredible promotion and you can hear about it here at WWHW! Between August 7, 2008 and December 23, 2008, you can get a room for only $51 a night. It is even cheaper than a motel room. Not only you get a great price, but you also get a $25 food and beverage credit and 2-for-1 tickets to Tournament of King’s dinner show. In order to receive this deal, go to Excalibur’s website and enter the following code when booking: “XBOTH2“.You can get this deal on Sunday – Thursday nights.Do you want a greater deal? By entering “BOTH” code you can get a room midweek for only $41. The only thing you’ll be missing is the 2-for-1 tickets and the food credit, but if you don’t care about them, this is definitely a good deal.Both deals end on August 20th.

How many Americans die from cigarette smoking every year?

400,000 Americans die from cigarette smoking every year. The number might frighten you, but it should also make you want to quit if you are a smoker. It is your choice in the end, but remember that no one wants you to become one of those numbers.The “painting” you see on the left was created by Chris Jordan. It is made entirely from cigarette packs (200,000 to be more exact). It mimics one of Van Gogh’s most macabre paintings: Skull with burning Cigarette.

(Click on Read more in order to see the next three of pictures depicting the “painting” in detail.) Continue reading “How many Americans die from cigarette smoking every year?”