Report

Auto inserting blank cell

Ask a question Satish - Last answered 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
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 
Helpful
+0
moins plus
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.
Add 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!