Hello Open Office, re: Extracting info from various columns in a Spreadsheet I have been using Open Office for years, it's a great tool. Can you please help me with the following; Let's say I have a Spreadsheet where multiple columns have data (say columns A-K), but I only need email addresses and names (say from column A & D). I need a list as follows; email address;name danad...@unitedyxxx.com;Dan Adams joelambr...@unitedyxxx.com;Joel Ambrose a...@unitedyxxx.com;Alex Andrades t...@unitedyxxx.com;Todd Astles How do I get a list with just the data from columns A & D, with a semi colon between the two? Thank You very much. Best Regards, Eric R. Sanders Eric R. Sanders RANDOLPH CAPITAL LLC www.Premium-Auctions.net
Tel 386-789-9441 "IMPORTANT LEGAL NOTICE: The foregoing message (including all attachments) contains CONFIDENTIAL and/or PRIVILEGED INFORMATION and is for the use of the intended recipient(s) only. It is covered by the Electronic Communications Privacy Act, 18 U.S.C. Sections 2510-2521. It contains CONFIDENTIAL and/or PRIVILEGED INFORMATION and may also be protected by other PRIVILEGE. If you are not the intended recipient of this message, you are hereby notified that any retention, dissemination, distribution or copying of this communication is strictly prohibited and subject to CRIMINAL and/or CIVIL SANCTIONS. Please reply to the sender that you have received this message in error, then permanently delete it and destroy all of its contents immediately."