CBHPE

Improve Student Learning with

ChromeBooks (and other devices)

in Health and Physical Education 

cbhpe (1).png
Tech It Up w border.png
  • Home

  • IDEA TANK

  • BackToSchool

  • Templates

  • Projector

  • GIFs

    • GIFs-1
    • GIFs-2
    • GIFs-3
    • GIFs-4
    • GIFs-5
  • Apps

  • hmm

  • EDI/Social Justice/SEL

  • Resources

  • 3D

  • HoF

  • About

  • More

    Use tab to navigate through the menu items.
    HMM-banner-logo.jpg
    To see this working, head to your live site.
    • Categories
    • All Posts
    • My Posts
    Becky Foellmer
    Jun 12, 2019

    Remove Line Breaks from a Google Sheet

    in HS PE Idea Tank

    Sometimes you may need data from a spreadsheet where the original owner used line breaks to separate the data within a cell. Perhaps you need that data, but without the line breaks. You can simply go to the "edit" menu, and choose "Find and Replace". From there, just type \r\n|\n|\r in the "find" box, and in the replace box type a comma, then a space. Click to select "Search using regular expressions" (which automatically selects "Match case"). Be sure you have selected where you want it to search (All sheets, This sheet, or Specific range) and then click "Replace all" - Voilà! All of the cells that previously included line breaks will have them all removed!


    0 comments
    0
    Comments

    Share Your ThoughtsSign up to leave a comment.

    0 comments

    @

    Contact Us:

    Mark Foellmer:  mfoellmer2@gmail.com

    Becky Foellmer: bfoellmer@gmail.com

    twitterbird_RGB_edited.png
    Follow us on Twitter:

    Mark Foellmer: @CoachFoe

    Becky Foellmer: @Foes4Sports