I am working on a Google Form where I need a drop down list of student names… first and last name. However, the names are not in the same cell in the spreadsheet.
Start with an Equals Sign
For all formulas in a spreadsheet you need to start with an equals sign. In a blank cell type the equals sign.
Ampersand Quotation Space Quotation Ampersand
The easiest way to concatenate (smash together) is to use the Ampersand (&) symbol.
You want to join the first and last name together… with a space. After typing your equal sign click on the cell that has the first name. AND you want a space. The & symbol means AND.
All Text Strings Go In Quotations
The space in between the first and last name is text. You will need “quotes” around the space.
AND you want the last name. So another & symbol. Now click on the last name to grab the cell reference. Press Enter.
Drag the Formula
Single click back on the cell where you entered the formula. Notice the fill down square in the bottom right corner of the highlighted cell.
Drag this down to continue the pattern of first and last name.
Paste Into Google Form
Highlight the entire list of first and last names. In a multiple choice question in a Google Form (or Drop down list) use Control V to paste into Option 1. This will paste the entire list of names all at once.