I am confident that you've been in a situation where you've been given a list of names. I'm going to guess you've felt the frustration of the list having the names in a single cell (probably lastname, firstname OR firstname lastname) but you really wanted them in separate cells. Or what about the reverse ... the list you've been given has the names in separate cells but you want them in the same (maybe separated by a comma?). Ugh. No need to retype the list! You can make your list be exactly what you want ... with very little effort!
I've made a video to demonstrate. It's right at 5 minutes. (Play it in 1.5 speed and will only take about 3 minutes). I've also tucked in a little *bonus* tip at the end ... did you know you can now specify the number of pixels tall you want your rows? Yep! I sneak that in, too!
As much as I love Google Sheets, I am NOT a Sheets expert. I have a lot to learn. I hope you take these nuggets and add to your learning adventure, too. Sheets really is a very versatile tool. Is there something you wish you knew how to do? Comment below or reach out on social media. All my links are just below my photo near the top right. I'd love to hear from you!
Looking to do more with Google Sheets? Check out:
- Level Up with Google Sheets (Summer 2021 webinar)