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 <[email protected]> Date: Thu, Oct 13, 2011 at 12:08 AM Subject: Re: $$Excel-Macros$$ Solution Request To: [email protected] 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 <[email protected]> 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 <[email protected]>wrote: > >> **Hi, >> >> Hope it helps. >> >> Regards >> >> Shiek >> >> On Wed, Oct 12, 2011 at 6:24 PM, dguillett1 <[email protected]>wrote: >> >>> You say “single LINE”. Do you mean one cell ? If so, NO. >>> >>> Don Guillett >>> SalesAid Software >>> [email protected] >>> >>> *From:* Ahmed Honest <[email protected]> >>> *Sent:* Wednesday, October 12, 2011 7:12 AM >>> *To:* [email protected] >>> *Subject:* $$Excel-Macros$$ Solution Request >>> >>> Dear All, >>> >>> If an excel file contains 1000's of emails ids in a column say as below : >>> >>> '[email protected] --- in Cell A1 >>> '[email protected] in Cell A2 >>> [email protected] --- in Cell A3 >>> [email protected] in Cell A4 >>> I need a formula to make all these email id as : *[email protected], >>> [email protected],[email protected],[email protected] ---- 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 [email protected] >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> 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 [email protected] >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> 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 [email protected] >> >> <><><><><><><><><><><><><><><><><><><><><><> >> 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 [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> 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
