You say “single LINE”. Do you mean one cell ? If so, NO. Don Guillett SalesAid Software dguille...@gmail.com
From: Ahmed Honest 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