| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Query in excel
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Query in excel
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Query in excel
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Query in excel
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Query in excel
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Query in excel
Web address are there for all the companies, but only email ID does not exist
in the companies. Ashwini "Kassie" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
| Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Hybrid Mode
