Skip to main content

Posts

Remove Blanks from Excel Sheet when Excel doesn't recognize field as blank

This is one of the tricks which always helped me in removing the blank fields from an Excel sheet especially when the values are copied from other sources. I have added screenshots of a sample data to show you all the actions step by step. Here are the steps to remove blanks by using one of the special functions in excel: 1. Select your data-set (Select the column which has blank values) 2. Press F5 3. Select "Special". You will see below screen: 4.Select Blanks and click Ok as shown 5. All the blank fields are now selected, you can proceed and delete all of them by selecting "delete" from the home menu.   Here is the final result: I hope this was helpful. Share this with your colleagues and friends to help them out.
Recent posts

How I cleared ISTQB Agile Extension Certification?

In this post I am going to share my experience and preparation for ISTQB Agile Foundation Level exam. The pre-requisite for this exam is ISTQB Foundation Level Certificate. This is an extension exam since it deals with only Agile development. Who is eligible for this exam? Every Tester who has ISTQB foundation level certificate is eligible. If you are planning to work in an agile environment or your current job demands so then you must go for this certificate since it will give you a basic idea of how Agile development works. What you will learn from the certification? After completing the certification, you will be able to understand how testing is a crucial part in agile. Role of a tester, how as a tester you can make a difference. Difference between Agile and Traditional methods. You will also learn about agile values and principles, continuous integration, planning, Kanban, XP and scrum methods. What is the exam structure? Exam consists of total 40 questions with multiple...