When you say exist in rows, is it all in one cell, varying cells, or what?
If in one cell, does each cell contain the words Address:, Phone:, Fax:, E
Mail:, web:, etc?


--
HTH

Kassie

Replace xxx with hotmail


"Ashwini" wrote:

Hi,

Accurate Engineering Works
Contact Address: Near Canal Bridge, Dugri Road, Ludhiana - 141002 Punjab
Phone : +91-161-2492554/2490553 Fax : +91-161-2492555
Email :
Web : http://www.accurate-group.com
Agrasen Engineering Industries Ltd
Contact Address: G-516 to 518, Road No: 9A, Vishwakarma Industrial Area,
Jaipur - 302013 Rajasthan
Phone : +91-141-2331716 Fax : +91-141-2332563
Email :
Web : http://www.agrasenengg.com/
Alien Fabricon
Contact Address: 1/B, Subhash Industrial Estate,Khokhara, Ramol Road,
Ahmedabad - 380026 Gujarat
Phone : +91-79-25855892 Fax : +91-79-25855890
Email :
Web : http://www.bottlingplantconveyor.com
Kolkata Branch: Wellesley House, South Gate, 7, Ground Floor, Red Cross
Place, Kolkata - 700001 West Bengal
Phone : +91-33-22306802/22489805 Fax : +91-33-22420868
Email :
Web : http://www.growel.com


The above list, consist in rows, Email ID & Web mail are not in all
companies. I have totally more than 500 companies, how to segregate into
Name, Address, Phone, Email & Web mail in columns.

Can you help me?

Regards,
Ashwini