Auto inserting blank cell [Closed]

Ask a question Satish - Last answered on Apr 26, 2010 at 10:06 AM 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

plus moins
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.

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!