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 wrote: > 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 > 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 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 >> wrote: >> >>> **Hi, >>> >>> Hope it helps. >>> >>> Regards >>> >>> Shiek >>> >>> On Wed, Oct 12, 2011 at 6:24 PM, dguillett1 wrote: >>> >>>> 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 >>>> >>>> <><><><><><><><
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 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 wrote: > >> **Hi, >> >> Hope it helps. >> >> Regards >> >> Shiek >> >> On Wed, Oct 12, 2011 at 6:24 PM, dguillett1 wrote: >> >>> 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 >>> >> >> >> >> -- >> 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 <><><><><><
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 wrote: > **Hi, > > Hope it helps. > > Regards > > Shiek > > On Wed, Oct 12, 2011 at 6:24 PM, dguillett1 wrote: > >> 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 >> > > > > -- > 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 it helps. Regards Shiek On Wed, Oct 12, 2011 at 6:24 PM, dguillett1 wrote: > 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 > -- 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
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
