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
