loknathmondal
New Member
- Joined
- Sep 1, 2015
- Messages
- 31
I Have data which is mentioned below.
[TABLE="width: 841"]
<colgroup><col></colgroup><tbody>[TR]
[TD]M/S Maharashtra Cylinders Pvt. Ltd., Near Railway Station, Post Kalmeshwar, Dist. Nagpur (Maharashtra)-[/TD]
[/TR]
[TR]
[TD]M/s. Indian Gas Cylinders, 14/1, Mathura Road, P.O. Amarngar, Faridabad –3[/TD]
[/TR]
[TR]
[TD]Universal Cylinders Ltd., 197, Matsya Industrial Area, Alwar –301030 (Raj)[/TD]
[/TR]
[TR]
[TD]M/s. Faridabad Metal Udyog Pvt. Ltd., 15/4, Mathura Road, Faridabad –121002[/TD]
[/TR]
[TR]
[TD]M/s. Interal Appliances Pvt. Ltd., Plot No. 87/3, Street No.17, MIDC, Indl. Area, Satpur, Nasik – 422007[/TD]
[/TR]
[TR]
[TD]M/s. Ideal Engineers Hyderabad Pvt. Ltd., Unit Noj.2, Plot No. 42, Co. Op. Industrial Estate, E. P. Gandhinagar, Hyderabad –37[/TD]
[/TR]
[TR]
[TD]M/s. Nagpur Fabriforge Pvt. Ltd., L-2, MIDC, Hingna Road, Nagpur –440016[/TD]
[/TR]
</tbody>[/TABLE]
I want to separate Company Name & Company Address.
If there is any formula to use or need to do manually?
Pls help
Regards
Loknath
[TABLE="width: 841"]
<colgroup><col></colgroup><tbody>[TR]
[TD]M/S Maharashtra Cylinders Pvt. Ltd., Near Railway Station, Post Kalmeshwar, Dist. Nagpur (Maharashtra)-[/TD]
[/TR]
[TR]
[TD]M/s. Indian Gas Cylinders, 14/1, Mathura Road, P.O. Amarngar, Faridabad –3[/TD]
[/TR]
[TR]
[TD]Universal Cylinders Ltd., 197, Matsya Industrial Area, Alwar –301030 (Raj)[/TD]
[/TR]
[TR]
[TD]M/s. Faridabad Metal Udyog Pvt. Ltd., 15/4, Mathura Road, Faridabad –121002[/TD]
[/TR]
[TR]
[TD]M/s. Interal Appliances Pvt. Ltd., Plot No. 87/3, Street No.17, MIDC, Indl. Area, Satpur, Nasik – 422007[/TD]
[/TR]
[TR]
[TD]M/s. Ideal Engineers Hyderabad Pvt. Ltd., Unit Noj.2, Plot No. 42, Co. Op. Industrial Estate, E. P. Gandhinagar, Hyderabad –37[/TD]
[/TR]
[TR]
[TD]M/s. Nagpur Fabriforge Pvt. Ltd., L-2, MIDC, Hingna Road, Nagpur –440016[/TD]
[/TR]
</tbody>[/TABLE]
I want to separate Company Name & Company Address.
If there is any formula to use or need to do manually?
Pls help
Regards
Loknath