Tips and Training from the Office of Technology Services
Below is a list of our upcoming free training workshops.
Wednesday, July 9
Blackboard Learn 9.1 April 2014 Release Update, 2 – 3 p.m., Online via WebEx
Wednesday July 9
Excel 2013: Introduction, 2 – 4 p.m., Cook 404A
Tuesday July 15
WebEx Information Session, 2 p.m. – 2:45 p.m., Online Via WebEx
Wednesday, July 16
Blackboard Learn 9.1 April 2014 Release Update, 10 – 11 a.m., Online via WebEx
Thursday, July 17
Blackboard Learn 9.1 April 2014 Release Update, 2 – 3 p.m., Online via WebEx
Wednesday, July 23
Word 2013: Working with Tables, LIsts and Charts, 1:30 – 3:30 p.m., Admin 113A
Wednesday, July 23
iOS 7 Tips & Tricks, 2:00 – 3:30 p.m., Cook 404A
To sign up for free technology workshops or view additional materials related to software training, visit OTS Training online. You can also contact us directly regarding any software training related issues at training@towson.edu or 410-704-4070. You can also follow us on Twitter.
Separate One Large Cell into Separate Cells
You may want to separate one large cell into two separate cells for sorting purposes. For example, you may want to separate a cell containing someone’s full name into two separate fields – one of those fields containing the first name and the other containing the last name. This will give you the ability to sort on either the last name field or the first name field.
1. Insert a blank column to the right of the large cell.
2. Select the cell you want to separate.
3. Click the Data tab on the Ribbon.
4. Click the Text to Columns button in the Data Tools group.
5. Make sure Delimited is chosen and click Next.
6. Choose the delimiter (Tab, Semicolon, etc) and click Next.
7. Choose the format (General, text, etc) and click Finish.
