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

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

Papa Kuʻi ʻai a me Pohaku

By
As part of our huakaʻi last month to Papahana Kuaola and the opportunity to work in the loʻi, I wanted to continue that thought by sharing my experience of making a papa kuʻi 'ai (poi-pounding board). In 2008 with the encouragement from me and my co-worker, Pili Wong, Earl Kawaʻa offered to teach a papa kuʻi ʻai papa to those of us that were interested in learning what our kūpuna did as a daily way of life. For our kūpuna they had loʻi in their yards and grew their own kalo, the major source of starch in their diet. They steamed it and pounded poi or kept it whole and sliced it and ate it like bread with butter or condensed milk. Kawaʻa was very specific on our kuleana and the commitment he required of us. Our first task was to find an au koʻi (handle) for our koʻi (adze tool). I found myself suddenly looking up at every tree I saw looking for the right branch for my koʻi. My husband found mine at a jobsite from a Haole Koa tree otherwise known as ...
Post a Comment
Read more