Auto inserting blank cell [Closed]

Satish - Apr 26, 2010 at 10:00 AM - Latest reply: rizvisa1 4482 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen
- Apr 26, 2010 at 10:06 AM
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
Site http://yellowpages.sulekha.com/...
Add1 Sector 6, Kalka Shimla Road
Add2 Parwanoo
City Parwanoo, 173220
State Himachal Pradesh
Tel Phone: (1792)233393
Category Public Schools


See more 

1 reply

rizvisa1 4482 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Apr 26, 2010 at 10:06 AM
0
Helpful
Could you please upload a sample file on some shared site like http://www.speedyshare.com/ and post back here the link to allow better understanding of how it is now and how you foresee.