Create Session Links
As an online tutor, I frequently need to send unique Zoom session links to my students. I have a 'Base Zoom URL' and a 'Meeting ID' for each session, and I need to combine them efficiently to create the full, clickable link.
=CONCATENATE(A2, B2) How it works: The CONCATENATE function joins two or more text strings into one. In this scenario, it takes the fixed 'Base Zoom URL' from cell A2 and appends the unique 'Meeting ID' from cell B2 directly after it, forming a complete and functional Zoom session link. This eliminates manual typing and reduces errors when preparing links for multiple students or sessions.
Data Setup
| Base Zoom URL | Meeting ID |
|---|---|
| https://zoom.us/j/ | 1234567890 |
| https://zoom.us/j/ | 0987654321 |
| https://zoom.us/j/ | 1122334455 |
Step-by-Step Guide
Enter your 'Base Zoom URL' (e.g., 'https://zoom.us/j/') in cell A2.
Enter the specific 'Meeting ID' for the session (e.g., '1234567890') in cell B2.
In cell C2 (or your desired output cell), type the formula: `=CONCATENATE(A2, B2)`.
Press Enter to see the combined session link.
Drag the fill handle (the small square at the bottom-right of cell C2) down to apply the formula to other rows, automatically generating links for all your sessions.