Auto inserting blank cell

Ask a question Satish - Last answered on Apr 26, 2010 10:06AM by rizvisa1
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
See 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.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!