Directory
Hi please help me.
Can anyone help to organize a directory? I have this Directory in HTML format
I need to clean this up to remove inactive contacts. When I converted it to excel format it comes out like this:
|
ContactCompanyRCB MinistriesAddressP.O. Box 288ContactAlice SanchezGreenhils,Title 0410 Metro ManilaPhone705-1355Ext. Country PhilippinesMobile Phone 917-7025-5058E-mail Philippines@rcbasia.org SalutationWeb Site Home Address Home Phone Ext. Home Address Pager Phone Ext. Personal E-mailcfamsden@sbcglobal.net Messenger ID Home Country Spouse
|
|
ContactCompany Asalus CorporationAddress7th floor, Feliza BuildingContactMichael Santos V.A. Rufino Street Title Makati CityPhone894-3386Ext. Country PhilippinesMobile Phone E-mail SalutationVeerinderWeb Site www.intellicare.com.ph Home Address Home Phone Ext. Home Address Pager Phone Ext. Personal E-mail Messenger ID Home Country Spouse
|
|
ContactCompanyMonde CorporationAddressP.O. Box ContactArmand Torres#3617 MCPOTitle Phone816-4466Ext. Country PhilippinesMobile Phone E-mail Salutation Web Sitewww.mondecorporation.com Home Address Home Phone Ext. Home Address Pager Phone Ext. Personal E-mail Messenger ID Home Country Spouse
|
How can I organize this in this format:
|
Company
|
|
|
Address
|
|
|
Contact Person
|
|
|
Title
|
|
|
Phone
|
|
|
Mobile
|
|
|
Website
|
|
|
|
|
|
Company
|
|
|
Address
|
|
|
Contact Person
|
|
|
Title
|
|
|
Phone
|
|
|
Mobile
|
|
|
Website
|
|
|
|
|
|
Company
|
|
|
Address
|
|
|
Contact Person
|
|
|
Title
|
|
|
Phone
|
|
|
Mobile
|
|
|
Website
|
|
Thank you.
| Attachment | Size |
|---|---|
| Contact.xls | 20 KB |
»
- fashmina's blog
- Login or register to post comments
- 5560 reads
Split contact
hi.. attached solution: Contact.xls
Split Contact
This can also be done in Word. In the Find-Replace dialog box (Ctrl+h) find the keywords and replace them with keyword+Tab (^t) e.g. for Company, Find: Company, Replace: ^pCompany^t and click replace all.
Note: ^p for Enter and ^t for Tab