Create Name Tags
As an event planner, I need to efficiently create name tags for attendees. Specifically, I need to combine each attendee's 'First Name' with their 'Table Number' so that both pieces of information appear clearly on a single line for printing on name badges. This needs to be done for a large list of attendees without manual entry, ensuring readability.
=CONCATENATE(A2, " - Table ", B2) How it works: The CONCATENATE function allows you to join multiple text strings into one. In this scenario, we're combining the attendee's first name (from cell A2), a literal text string ' - Table ' (enclosed in double quotes to include spaces and descriptive text), and their assigned table number (from cell B2). This creates a single, formatted string like 'Alice - Table 5', which is perfect for printing on a name badge, making it easy for attendees to find their assigned table.
Data Setup
| First Name | Table Number |
|---|---|
| Alice | 5 |
| Bob | 12 |
| Charlie | 3 |
| Diana | 8 |
Step-by-Step Guide
Open your attendee list in Excel. Ensure you have 'First Name' in one column (e.g., Column A) and 'Table Number' in another (e.g., Column B).
Select an empty cell in a new column where you want the combined name tag text to appear (e.g., C2).
Enter the formula: `=CONCATENATE(A2, " - Table ", B2)` (adjust A2 and B2 to match the first row of your actual data, assuming headers are in row 1).
Press Enter to see the combined text for the first attendee.
Drag the fill handle (the small green square at the bottom-right corner of cell C2) down to apply the formula to all other attendees in your list.