Clean up imported or pasted data in Excel - http://blogs.office.com/b...
Sep 21, 2011
from
"The data in your beautiful spreadsheet doesn't necessarily start out that way, especially if you've copied or imported it in from some other place. By using some Excel functions and formatting techniques, you can make your names, dates and numbers look just the way you want."
- LANjackal