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.com>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 <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.com>wrote: >> >>> **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 >> > > > > -- > 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 > > > > -- > 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