Skip to main content

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.



Labels

Labels:

Comments

Post a Comment

Share your feedback

Popular posts from this blog

Benefits of Early and Frequent Feedback in Agile development

One of the reasons why Agile is preferred over traditional development method is "Early and Frequent Customer Feedback". This is not only helps customer to get what he wants but also helps development team to understand the requirement better. There is no room for misunderstandings and delays. so no BAD CUSTOMER SERVICE! In this post, I am going to discuss about some of the major benefits of early and frequent feedback in Agile. One way to get the early feedback is "CI" or Continuous Integration. There are many tools available in the market like Jenkins which help in running automated tests when a change is introduced in the build and give the feedback on the build performance or quality. Below are some of the advantages of early and frequent feedback: Early and regular feedback helps in clearing out the misunderstanding of the requirements. Unlike in traditional method, fixing the issues or requirements change is a lot less expensive. Customer get to see the...
Post a Comment
Read more

Testing is inevitable!

Welcome to Software Testing Techie Blog! Today I am going to write about something which we all observe but not pay enough attention to! Testing is something which is innate in all of us! Yes, we all are testing throughout our life :) The main reason could be the human behavior of not trusting anything. Remember the time when we were young and had a play guitar which was our favorite toy. How much testing was performed on it? We played with it until we broke it completely. Hilarious! Now observe a child when he is given anything to eat, he starts testing it by mashing it on the ground, looking at it number of times, beating it again and again and finally when he feels like it is good, he takes it in his mouth to eat. Testing is one of the most interesting fields, unlimited number of ways to test a particular software. But to enjoy testing, the only condition is to open up your mind and test. You will find that you are learning something new everyday and your job woul...
Post a Comment
Read more