Skip to main content

Excel Tip!

By
I wanted to post about one of the many functions in Excel. With the many master lists we have, we are always trying to sort through them for specific data. I remember when Davie was working on sorting emails for the newsletter, she said she had trouble with pulling only “@ksbe.edu” email addresses. I knew MS Excel did a lot but wasn’t sure that it would do this. So I did a little research and asked my husband (the Excel Dork).

To pull specific data from a field you will need to do the following:
  1. Create a column.
  2. In the first box you will need to specify which series of text you’d like to sort so if were looking for “@ksbe.edu”, you will type in “=RIGHT()” or use the function library to find the TEXT function and select RIGHT.
  3. Select the group of data you’re asking this function to search, and the number of characters you'd like to sort counting from the right hand side of the field.
  4. Copy and paste the formula for all the fields you'd like the data to be pulled from.
  5. The resulting column will be something like this:
  6. Now you have a workable column in which to sort your data.

I hope this tip helps in our quest for pulling information! The same method works for pulling data characters from the left hand side as well.

Comments

Post a Comment

Popular posts from this blog

Schools of the Future: Acquiring and Representing Knowledge

By
This year's Schools of the Future conference was an information-rich event. When we think of the future, more than a few of us probably also think of technology. That association certainly carries over in the interpretation of the conference title Schools of the Future . Indeed, many topics besides educational technology were covered; however, the technological advances were a strong highlight at the conference in my view. As mentioned in one of Cassie's previous posts , there are online classes everywhere. The first few links on my list reference ways to learn on your own (i.e., ways to acquire knowledge). The second set of links refer to ways of representing knowledge. **Note:  All icons link to the affiliated website.  Academic Earth has hundreds of free online lectures from prominent university professors, including Carnegie Mellon, Stanford, The University of Houston, Cornell, Dartmouth, Harvard, MIT, Michigan State, Princeton, Rice, UCLA, UCSF, and the list
Post a Comment
Read more

Geotagging

By
A "wouldn't it be nice" idea that's been around a while is the ability to tag a map with images that are linked to more information about the site. Kelly C suggested it as a way for students to share knowledge about a cultural/historic site or the geographic area they live in with classmates. (right, no addresses!) There are now cameras and even storage media that embed latitude and longitude into images as they are shot. But you don't need fancy new toys to do this. I tried Flickr's geotagging map and it's fun and supereasy. Want to try it? Log in to Flickr http://www.flickr.com Sign in as " techedine " password " wist101 " yea, corny. Click the " You " tab then the " Your Photostream > Map " or Organize > Your Map links. Click the Satellite link in the upper right. Cool view! (you may need Google Satellite downloaded). Images along the bottom of the screen with colored dots have already been droppe
6 comments
Read more

Zoho Creator

By
I thought I’d share this web application I came across in my quest to find a relatively simple app to help us manage our mentoring data in the DL Orientation. Our specific needs were that it be a free online database, password protected, had the capability of rapid form development without too much programming knowledge and was easy for the end user to use. The application that met these requirements was Zoho Creator ( http://www.zohocreator.com/ ) a part of a suite of online applications including word processing, spreadsheets, presentations, wikis, organizers and more. What’s great about Zoho Creator is that they have an online repository of applications already developed that you can download to your account and use for free. Initially, I tried some of these applications, but it was overkill for our needs. Zoho Creator can do a lot if you know programming and they have a pay model where it allows you more flexibility and features. I think Zoho Creator would be a useful tool for both
6 comments
Read more