Here's a fun macro that formats text in an Excel spreadsheet for posting on the message boards.The file is named ExportText.xls and is at http://briefcase.yahoo.com/TheGreatRadishHere's how it works:1. Bring up the spreadsheet you want to post in Excel.2. Open the ExportText.xls spreadsheet.3. Go back to your spreadsheet, by typing ctrl-F6 (or using the Window menu item).4. Highlight the area on the spreadsheet you want to post.5. To run the macro type alt-F8 (or Tools | Macro | Macros...), highlight ExportText, and click on Run.6. The macro asks how many spaces you want between columns, and whether or not you want to left-align everything. If you don't left-align everything, it will use the Left, Center, and Right settings you've applied to each cell or if no alignment has been applied it will right-align numbers and left-align everything else.7. You'll find somewhere on your hard drive a file named ExportText.txt. Double-click on it to open it with notepad.8. Select all the text (using Edit | Select All, or ctrl-A on newer versions of Notepad) and type ctrl-C to copy it to the Windows clipboard. Close Notepad.9. In your post, use ctrl-V to paste the text in. Remember to put <PRE> in front of the text and </PRE> after it.10. Click on Preview Message to make sure your post is a happy post.11. Delete the ExportText.txt file from your hard drive.Enjoy,Phil
Best Of |
Favorites & Replies |
Start a New Board |
My Fool |
BATS data provided in real-time. NYSE, NASDAQ and NYSEMKT data delayed 15 minutes.
Real-Time prices provided by BATS. Market data provided by Interactive Data.
Company fundamental data provided by Morningstar. Earnings Estimates, Analyst Ra