Concatenate formulas take data from different columns and joins them together.
Earl E. Bird becomes Bird, Earl E.
"Split" takes two or more words in a cell and inserts each into a new column.
Bird, Earl E. becomes Bird Earl E.
Copy the CONCATENATE formula down the column by dragging the plus sign.
The screenshot below shows how to concatenate to create an email address.
copyDown is a spreadsheet add-on will copy a formula down the column as each row is filled. This is helpful for things like totaling scores that you submit on a form. BTW, just like autoCrat, copyDown was created by CloudLab New Visions for Public Schools
Save as Doc is an addon for sheets that allows you to take long, open-ended questions on a form, and make them a little easier to read by adding it to a document.