Northern Media Center
  • Home
    • Media Center Policies
    • Public Library Resources
    • Computer Lab Schedules
  • Research
    • Electronic Resources
    • Online Research Sources
    • Searching the Web
    • Searching Databases
    • MLA Citation
    • Plagiarism >
      • Paraphrasing and Summarizing
      • Copyright and Fair Use
    • Website Evaluation
  • Courses
    • AP Research
    • Ms. Pauley Mr. Ramamurthy Senior Project
    • Mrs. Vansciver's Project
    • Mr. Pauley's and Mrs. Looney's Happiness Research
  • Resources
    • Subject Area Resources >
      • Math
      • English
      • History
      • Science
      • World Languages
      • Visual and Performing Arts
      • Health/Physical Education
    • Parent Resources
    • Student Resources >
      • College/Career Exploration >
        • College Exploration
        • Career Exploration
      • PSAT Resources
      • Homework Help
      • Note Taking Forms
    • Teacher Resources >
      • Google Drive Presentation
    • Technology Tools
  • About Me
    • Cute Cats
    • Publications

Merge Values Add On

4/15/2014

0 Comments

 
Merge Values is an add-on that you can use on Google Sheets.  This is great when you have items in columns in a spreadsheet where you would like them to merge into one cell.  The concatenate formula I have used in the past allows you to do this, but I have had to maintain the data in the cells being combined or use extra steps to extract the combined cells.  For example, I create spreadsheets with student names and user IDs on them.  Their Google apps account requires the email address, so I need to append @schooldomain.com to each student's user id.  Merge Values allows me to do this very easily.

After I installed the Add-on, I created a spreadsheet with the names and User Ids.  Then I created a column with @schooldomain.com down the entire column.  When I started the Merge Values Add-on, a sidebar appeared with various options:
Picture
There is a variety of options, but by clearing the contents of the selected cells and deleting options to separate the values, I was able to create the student IDs as email addresses much more quickly than I had in the past.

If you would find it useful to merge data from cells in a spreadsheet, open a new spreadsheet, go to Add-ons, go to Get Add-Ons, and install the Merge Values add on.
0 Comments



Leave a Reply.

    Mrs. Humes

    Teacher, Librarian, Writer, Technophile.

    Embed

    Archives

    October 2014
    July 2014
    June 2014
    May 2014
    April 2014

    Categories

    All
    Add Ons
    Add-ons
    App
    Assessment
    Classroom
    Docs
    Drive
    Editing
    Edmodo
    Extension
    File Sharing
    Folder
    Form
    Google
    Image
    Kindle
    Languages
    Mood
    Organize
    Reading
    Recovery
    Screenshot
    Sheets
    Sound
    Tabs
    Text To Speech
    Windows
    Writing

    RSS Feed

    CC Attribution:  
    Photos by Simon Cocks (https://www.flickr.com/photos/simon_cocks/).  Original images were cropped, had color modification, and had text added. 
Site Map
last updated November 13, 2020