One of my colleagues was setting up around 400 student accounts for the new year today. He had an Excel spreadsheet with Firstname and Lastname in seperate cells A and B and needed to add two more columns with the students login name (cell C) and email address (cell D). At first he thought this … Continue reading Join multiple cells in Microsoft Excel using the CONCATENATE function