Thanks. When you say most companies do not have email and web addresses,
does that mean that records can contain up to 2 rows less than the ones that
do have? It would appear like that. :-)
Best way would be to use a macro to do the move for you, just want to
clarify the varying numbers of rows per entry first.

--
HTH

Kassie

Replace xxx with hotmail


"Ashwini" wrote:

D1 : ABM Tools
D2: Contact Address: 79A, Pocket GG-1, Vikaspuri, New Delhi - 110018 Delhi
D3: Phone : + 91-11-28546891 Fax : +91-11-28540898
D4: Email :
D5:Web : http://www.abmtools.com
D6:Growel
D7:Contact Address: Akurli Road, Kandivali(East), Mumbai - 400101 Maharastra
D8:Phone : +91-22-66993200 Fax : +91-22-66993030
D9:Web : http://www.growel.com

Email ID does most of the companies does not have.

Regards,

"Kassie" wrote:

Let me try again. If you say in one row per entry, is one customer record in
one cell, or in more than one cell in that row. Also, does each entry then
contain the key words Address:, Phone: etc.

--
HTH

Kassie

Replace xxx with hotmail


"Ashwini" wrote:

Hi,

It's in different rows.

Ashwini

"Kassie" wrote:

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