Waffle Bytes

(Part of my administrative assistant series on Google Sheets.) Below is a summary of all the topics covered in Session #3 of the series I have been doing for support staff.  This one covered several "intermediate" formulas available to use with Google Sheets.  We especially focused on formulas that would be useful to those school employees that would be working with large numbers of student data. Session 3 - Intermediate Formulas (November 29, 2017) Split Formula Concatenate Formula Count Formulas Hyperlink Formula

(Part of my administrative assistant series on Google Sheets.) The other task that can be labor intensive without a formula is joining fragments together into a single cell.  I can actually remember spending a whole DAY once creating student accounts that followed a certain pattern so I could upload them for auto-account creation in an online system.  This was for a single grade...and certainly not so "auto" especially considering I could have saved my day as there is an EASY way to do this :-) Similar to SPLIT, the formula needs to be applied to each item you want to split - however, using the fill capability can make that quick work.   CONCATENATE Joins data together in one cell; it can use cell references and/or fixed data.  If it is only 2 pieces of data, it can be shortened to CONCAT Example: =CONCAT(C2, "19") This will join the value of 19 to the value that is in C2. Here is an example of it -  Example:  =CONCATEN...