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
