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
Sample of email Ids.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
