Re: $$Excel-Macros$$ Solution Request
Hi Ahmed, I think Mr.Guillet was correct,as if i am right one cell in excel can hold only 32,767 characters, if you have thousands of mail ids then it may exceed this limit. On Thu, Oct 13, 2011 at 12:34 AM, Ahmed Honest ahmedhon...@gmail.comwrote: Dear Mr. Chethan, Just a Lovely, Damm and Beyond imagination solution. You Made my Day. I am speechless for your solution. Billions of Thanks...! Dear Mr. Don Guillet, Thanks for your input as well, but would like to request you to go through the solution how this has been achieved this will enlighten your knowledge as well. As you said me NO. But anyways thanks for sparing your time. Regards Ahmed Bawazir -- Forwarded message -- From: B.N.Chethan kumar chetankumar1...@gmail.com Date: Thu, Oct 13, 2011 at 12:08 AM Subject: Re: $$Excel-Macros$$ Solution Request To: excel-macros@googlegroups.com Hi, Hope these help, Drag the file down untill last row of the data sheet. On Wed, Oct 12, 2011 at 6:40 PM, Ahmed Honest ahmedhon...@gmail.comwrote: Dear Mr. Shiek, Tons of thanks for your help. I hope that U achieved it by VBA but is there any formula of excel to achieve this? Dear Mr. Don Guillet, Thanks for your inputs as well...! Regards Ahmed Bawazir On Wed, Oct 12, 2011 at 4:02 PM, Shiek Peer Mohd shiekp...@gmail.comwrote: **Hi, Hope it helps. Regards Shiek On Wed, Oct 12, 2011 at 6:24 PM, dguillett1 dguille...@gmail.comwrote: You say “single LINE”. Do you mean one cell ? If so, NO. Don Guillett SalesAid Software dguille...@gmail.com *From:* Ahmed Honest ahmedhon...@gmail.com *Sent:* Wednesday, October 12, 2011 7:12 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Solution Request Dear All, If an excel file contains 1000's of emails ids in a column say as below : 'pi...@gmail.com --- in Cell A1 'ti...@gmail.com--- in Cell A2 li...@yahoo.com --- in Cell A3 zi...@yahoo.com--- in Cell A4 I need a formula to make all these email id as : *pi...@gmail.com, ti...@gmail.com,li...@gmail.com,zi...@gmail.com i.e Each email id separated by comma but in a single line. But please note i have 1000's of records so want to convert these into a single line.* ** Waiting in anticipation for your help...! ** ** -- Ahmed Bawazir *احمد باوزير* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards, Shiek -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Ahmed Bawazir *احمد باوزير* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- B.N Chetan kumar
$$Excel-Macros$$ Solution Request
Dear All, If an excel file contains 1000's of emails ids in a column say as below : 'pi...@gmail.com --- in Cell A1 'ti...@gmail.com--- in Cell A2 li...@yahoo.com --- in Cell A3 zi...@yahoo.com--- in Cell A4 I need a formula to make all these email id as : *pi...@gmail.com, ti...@gmail.com,li...@gmail.com,zi...@gmail.com i.e Each email id separated by comma but in a single line. But please note i have 1000's of records so want to convert these into a single line.* ** Waiting in anticipation for your help...! ** ** -- Ahmed Bawazir *احمد باوزير* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Solution Request
You say “single LINE”. Do you mean one cell ? If so, NO. Don Guillett SalesAid Software dguille...@gmail.com From: Ahmed Honest Sent: Wednesday, October 12, 2011 7:12 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Solution Request Dear All, If an excel file contains 1000's of emails ids in a column say as below : 'pi...@gmail.com --- in Cell A1 'ti...@gmail.com--- in Cell A2 li...@yahoo.com --- in Cell A3 zi...@yahoo.com--- in Cell A4 I need a formula to make all these email id as : pi...@gmail.com,ti...@gmail.com,li...@gmail.com,zi...@gmail.com i.e Each email id separated by comma but in a single line. But please note i have 1000's of records so want to convert these into a single line. Waiting in anticipation for your help...! -- Ahmed Bawazir احمد باوزير -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Solution Request
**Hi, Hope it helps. Regards Shiek On Wed, Oct 12, 2011 at 6:24 PM, dguillett1 dguille...@gmail.com wrote: You say “single LINE”. Do you mean one cell ? If so, NO. Don Guillett SalesAid Software dguille...@gmail.com *From:* Ahmed Honest ahmedhon...@gmail.com *Sent:* Wednesday, October 12, 2011 7:12 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Solution Request Dear All, If an excel file contains 1000's of emails ids in a column say as below : 'pi...@gmail.com --- in Cell A1 'ti...@gmail.com--- in Cell A2 li...@yahoo.com --- in Cell A3 zi...@yahoo.com--- in Cell A4 I need a formula to make all these email id as : *pi...@gmail.com, ti...@gmail.com,li...@gmail.com,zi...@gmail.com i.e Each email id separated by comma but in a single line. But please note i have 1000's of records so want to convert these into a single line.* ** Waiting in anticipation for your help...! ** ** -- Ahmed Bawazir *احمد باوزير* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards, Shiek -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Consolidate.xlsm Description: Binary data
Re: $$Excel-Macros$$ Solution Request
Dear Mr. Shiek, Tons of thanks for your help. I hope that U achieved it by VBA but is there any formula of excel to achieve this? Dear Mr. Don Guillet, Thanks for your inputs as well...! Regards Ahmed Bawazir On Wed, Oct 12, 2011 at 4:02 PM, Shiek Peer Mohd shiekp...@gmail.comwrote: **Hi, Hope it helps. Regards Shiek On Wed, Oct 12, 2011 at 6:24 PM, dguillett1 dguille...@gmail.com wrote: You say “single LINE”. Do you mean one cell ? If so, NO. Don Guillett SalesAid Software dguille...@gmail.com *From:* Ahmed Honest ahmedhon...@gmail.com *Sent:* Wednesday, October 12, 2011 7:12 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Solution Request Dear All, If an excel file contains 1000's of emails ids in a column say as below : 'pi...@gmail.com --- in Cell A1 'ti...@gmail.com--- in Cell A2 li...@yahoo.com --- in Cell A3 zi...@yahoo.com--- in Cell A4 I need a formula to make all these email id as : *pi...@gmail.com, ti...@gmail.com,li...@gmail.com,zi...@gmail.com i.e Each email id separated by comma but in a single line. But please note i have 1000's of records so want to convert these into a single line.* ** Waiting in anticipation for your help...! ** ** -- Ahmed Bawazir *احمد باوزير* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards, Shiek -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Ahmed Bawazir *احمد باوزير* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Solution Request
Hi, Hope these help, Drag the file down untill last row of the data sheet. On Wed, Oct 12, 2011 at 6:40 PM, Ahmed Honest ahmedhon...@gmail.com wrote: Dear Mr. Shiek, Tons of thanks for your help. I hope that U achieved it by VBA but is there any formula of excel to achieve this? Dear Mr. Don Guillet, Thanks for your inputs as well...! Regards Ahmed Bawazir On Wed, Oct 12, 2011 at 4:02 PM, Shiek Peer Mohd shiekp...@gmail.comwrote: **Hi, Hope it helps. Regards Shiek On Wed, Oct 12, 2011 at 6:24 PM, dguillett1 dguille...@gmail.comwrote: You say “single LINE”. Do you mean one cell ? If so, NO. Don Guillett SalesAid Software dguille...@gmail.com *From:* Ahmed Honest ahmedhon...@gmail.com *Sent:* Wednesday, October 12, 2011 7:12 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Solution Request Dear All, If an excel file contains 1000's of emails ids in a column say as below : 'pi...@gmail.com --- in Cell A1 'ti...@gmail.com--- in Cell A2 li...@yahoo.com --- in Cell A3 zi...@yahoo.com--- in Cell A4 I need a formula to make all these email id as : *pi...@gmail.com, ti...@gmail.com,li...@gmail.com,zi...@gmail.com i.e Each email id separated by comma but in a single line. But please note i have 1000's of records so want to convert these into a single line.* ** Waiting in anticipation for your help...! ** ** -- Ahmed Bawazir *احمد باوزير* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards, Shiek -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Ahmed Bawazir *احمد باوزير* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- B.N Chetan kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Sample of email Ids.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Fwd: $$Excel-Macros$$ Solution Request
Dear Mr. Chethan, Just a Lovely, Damm and Beyond imagination solution. You Made my Day. I am speechless for your solution. Billions of Thanks...! Dear Mr. Don Guillet, Thanks for your input as well, but would like to request you to go through the solution how this has been achieved this will enlighten your knowledge as well. As you said me NO. But anyways thanks for sparing your time. Regards Ahmed Bawazir -- Forwarded message -- From: B.N.Chethan kumar chetankumar1...@gmail.com Date: Thu, Oct 13, 2011 at 12:08 AM Subject: Re: $$Excel-Macros$$ Solution Request To: excel-macros@googlegroups.com Hi, Hope these help, Drag the file down untill last row of the data sheet. On Wed, Oct 12, 2011 at 6:40 PM, Ahmed Honest ahmedhon...@gmail.com wrote: Dear Mr. Shiek, Tons of thanks for your help. I hope that U achieved it by VBA but is there any formula of excel to achieve this? Dear Mr. Don Guillet, Thanks for your inputs as well...! Regards Ahmed Bawazir On Wed, Oct 12, 2011 at 4:02 PM, Shiek Peer Mohd shiekp...@gmail.comwrote: **Hi, Hope it helps. Regards Shiek On Wed, Oct 12, 2011 at 6:24 PM, dguillett1 dguille...@gmail.comwrote: You say “single LINE”. Do you mean one cell ? If so, NO. Don Guillett SalesAid Software dguille...@gmail.com *From:* Ahmed Honest ahmedhon...@gmail.com *Sent:* Wednesday, October 12, 2011 7:12 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Solution Request Dear All, If an excel file contains 1000's of emails ids in a column say as below : 'pi...@gmail.com --- in Cell A1 'ti...@gmail.com--- in Cell A2 li...@yahoo.com --- in Cell A3 zi...@yahoo.com--- in Cell A4 I need a formula to make all these email id as : *pi...@gmail.com, ti...@gmail.com,li...@gmail.com,zi...@gmail.com i.e Each email id separated by comma but in a single line. But please note i have 1000's of records so want to convert these into a single line.* ** Waiting in anticipation for your help...! ** ** -- Ahmed Bawazir *احمد باوزير* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards, Shiek -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Ahmed Bawazir *احمد باوزير* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- B.N Chetan kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http