Monday, April 25, 2011

Dividing Text in Excel

Application: Microsoft Excel 2007 & 2010


Have you ever needed to separate last name and first names in an excel spreadsheet? There are frequently times when spreadsheet data needs to be divided into more granular information in order to better sort, filter, alphabetize, or use in a mail merge independently.
Spreadsheets can be updated with Excel’s Text to Column command that can divide the data into separate columns.


Divide data in one column
*These steps apply to data where a space is used to divide. For data that is divided by commas or other, please see the article listed below.
1. Insert a column(s) where the divided data will be placed.
2. On the Data ribbon, select Text to Columns.
3. The Text to Columns Wizard will appear. In Step 1, select Delimited.
4. Click Next. In Step 2, select Space. Be sure to uncheck all other options.
5. Click Next. In Step 3, select Text.
6. Click Finish.

             
        becomes



For more information about this feature, please visit the Microsoft Office article.

Monday, April 11, 2011

Web 2.0 Tool of the Week: Second Life

Second Life is a 3-D virtual world entirely built and owned by its Residents. Since opening to the public in 2003, it has grown explosively and today is used by universities, businesses and individuals from around the globe.


An Invitation to See Second Life in Action
On April 12-13, TWU will host the Annual Student Creative Arts and Research Symposium. TWU uses Second Life during the symposium to allow students to present a virtual poster from off campus. As in real-life, presenters attend one session of the symposium by logging into Second Life from a computer and having their avatar present during a session. Students present their research to a global audience in addition to the visitors on the TWU campus.
A real-life viewing of Second Life will be available in ACT 225 and is open to the public. Student research will be presented at the following times in world:


Tuesday, April 12
12:00-12:50 p.m.
6-7:20 p.m.


Wednesday April 13
9-10:20 a.m.
12:15-1:00 p.m.
6-7:20 p.m.


In addition to a guided tour in ACT 225, visitors are welcome to try Second Life hands on in ACT 603 or from the convenience of your home. We invite you to join us in this celebration of student research!