I can hardly believe that spring break is already over! I hope you all got rested and rejuvenated for our final push of Spring 2011.
Tomorrow we are going to work on text tools in Excel. Here is a video that does a pretty good job...
the only thing I would recommend to the author is to use the RIGHT function to pull out the state abbreviations instead of MID. The formula would read =RIGHT(cell reference, 2).
Here is a short, kinda blurry video on Text to Columns, but I think you can get the idea:
If you haven't already done so, and would like to earn 2 extra DPQ points, please refer to the last blog post and complete the survey on your usage of the videos!
See you tomorrow.
No comments:
Post a Comment