These extra time-saving techniques are the icing on the cake.
Use the & operator to concatenate letters and numbers from a few different cells into a single cell. In this example, I combine first names from one column and last names from another column into a single column that displays the First Last format.
Simplify your survey’s timestamp data by focusing on just the details you need, like the month and day that the survey was submitted.
Need to create random numbers, make up some fake data for your spreadsheet, or randomly assign participants to a treatment or control group? Use the randbetween function.
Use the left, mid, and right formulas to parse your ID numbers.