Combine First and Last Names for Roster
I have student first names in column A and last names in column B and need to merge them into 'Last, First' format.
=TEXTJOIN(", ", TRUE, B2, A2) How it works: The TEXTJOIN function concatenates a list or range of text strings using a delimiter you specify. Here, we use ', ' as the delimiter. The `TRUE` argument tells TEXTJOIN to ignore any empty cells. We then specify the last name (B2) and the first name (A2) in the desired order to achieve the 'Last, First' format.
Data Setup
| First Name | Last Name |
|---|---|
| John | Doe |
| Jane | Smith |
| Peter | Jones |
Step-by-Step Guide
Select the cell where you want the combined name to appear (e.g., C2).
Type the formula: `=TEXTJOIN(", ", TRUE, B2, A2)`
Press Enter. The name will appear as 'Doe, John'.
Drag the fill handle (the small square at the bottom-right of cell C2) down to apply the formula to the rest of your student list.
Explore More
Count Students Who Passed the Exam
I need to quickly count how many students scored above 60 in the final math exam.
Retrieve Student Guardian Contact Info
I have a student ID in one sheet and need to pull their guardian's email address from the school registry.
Assign Letter Grades Based on Score
I want to automatically assign 'A', 'B', 'C', or 'F' based on the numeric score in the adjacent cell.
Sum Points for Specific Assignment Type
As a teacher, I want to calculate the total points earned across all students specifically on 'Homework' assignments, ignoring other assignment types like quizzes or exams. This helps me track overall progress for a particular category of work.