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