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

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

Avatar Chat

By
Aloha all, Here's my o wau topic for this week. We all know the power of the Avatar and their popularity with our learners from our A`o Makua courses and I know we have discussed ways to incorporate them into our `Ike Hawai`i classes as well. Well, I can't take credit for finding this resource. Our resident Avatar expert a.k.a. Christy told me to check it out because Avatars can now chat. So please join me in finding out what other engaging and motivating feats these amazing characters can do to help us provide meaningful learning experiences for all our students. You can read about OddCast and their AvatarSpace or go to their Web site and test out some of these features. I'm hoping that this may provide us with a motivating way to get students, in both programs, to participate in some cooperative learning and sharing. Let me know what you think and if you feel this would be a valuable application to use. Mahalo - look forward to reading your responses! Kelly
5 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