=CONCATENATE

The =CONCATENATE function allows you to string text together in a cell. It works identically in both Sheets and Excel and I really dig it. In the past I’ve used it to create Dashboards that make sense for students.

But now I’ve decided to try and use it to make email lists of students. I’m not sure if you struggle as much as I do to student emails from the databases in large numbers, but this ended up making a nice little solution for that problem.

Excel

Google Sheets

If you’ve found any fun and interesting uses of the CONCATENATE function, let me know. Subscribe to the channel if you’re into the Spreadsheet videos and let me know of any functions you’d be interested in me exploring.

Stay shiny Pony-Boy,

Pete

@Mr_van_w