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

Scratch - OWAU discussion 10/28

By Anonymous
Aloha kākou, I while back, I learned about this product from a presentation at the eSchool conference. The speaker was so excited about Scratch and was having so much fun demonstrating it that my mind began racing immediately. "I could use it in `Ike Hawai`i courses and I bet I could use it to develop tons of activities for the A`o Makua `ōlelo Hawai`i courses". Then, reality set in as I returned to work intending to try it out after I finished my "next" task. Well, you know how that goes. 7 months later, I finally took a stab at it out of necessity of course. I really wanted some type of activity to teach my students about different Kapu in old Hawai`i without having them just read a list of them. So, what it Sratch? Simply put, it's a developer's tool (a very inexpereinced developer like myself). It allows you to create activities and games using "coding" that is in a drag and drop format. The codes are pre-written & range from phrases like ...
8 comments
Read more

3/19 Owau: FaceBook CourseFeed & Blackboard

By
Initially when I first joined FaceBook, it was because I wanted to see what the hype was all about since many of our learners seem to be hooked onto this social networking site. After I set up an account, I didn't do much until my friends from high school, college and even my own family (including my dad) started inviting me to be their "friend" to network together. It was only until recently that I realized why our students would probably prefer logging into Facebook first before even thinking about opening up Blackboard to begin their online course. Once your network of friends is set up, it's definitly an easy way to keep updated on what's going on at a distance. I really haven't done much in Facebook besides the basics, but I thought it would be interesting for us to look at the CourseFeed interface ( http://apps.facebook.com/coursefeed ) that was developed. CourseFeed is a free Blackboard Building Block and Facebook app that alerts students in Faceboook w...
7 comments
Read more

E pule kakou . . .

By
Aloha all, I was trying to think so hard of a "techie" tip and finally gave up. I even googled "tips and tricks" for various programs and then thought "I can't blog about something I don't actually use!" Then, as I was sitting in my Papa Makua class, doing all kinds of protocal and thought about how we keep looking for a short pule to do to open our meetings. I had `A`ali`i write a pule in Hawaiian. He was worried about the grammar and structure of it so I asked Kelly C. to kökua by editing and doing an audio recording so you can hear the pronunciation. Hope it's helpful :) E ho`omalu käkou E kö mäkou makua i loko o ka lani Mahalo no nä pömaika`i a pau. Mahalo no ke ali`i lokomaika`i o Pauahi a me këia kula nei. E `olu`olu, e kia`i iä mäkou i ke alahele küpono me ka lökahi. Ke nonoi ha`aha`a nei mäkou i ka inoa o Iesu Cristo `Ämene `Unuhi (translation): Let us pray Our Father in heaven Thank you for all the many blessings. Thank you for the gen...
Post a Comment
Read more