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