Ask a question Report

Auto inserting blank cell

Satish - Latest answer on Apr 26, 2010 10:06AM
I have a excel with huge data which is give below. But somewhere the fields are not exact suppose somewhere add2 content is not there. I want to put a blank cell in front of the Add2 cell automatically. Please help me ...................Thanks a lot
Name Eicher School
Add1 Sector 6, Kalka Shimla Road
Add2 Parwanoo
City Parwanoo, 173220
State Himachal Pradesh
Tel Phone: (1792)233393
Category Public Schools
Read more 

moins plus
Could you please upload a sample file on some shared site like and post back here the link to allow better understanding of how it is now and how you foresee.
Add comment
This document entitled « Auto inserting blank cell » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.

Not a member yet?

sign-up, it takes less than a minute and it's free!

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.