**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