Using Custom Functions: Introduction to Programming with Google Sheets 08-B
Here we step through how to write custom functions using string variables and concatenation as an example.
You can find the playlist for all videos in this course here: http://gr1.me/ipgs