Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
Welcome to this tutorial on combining text in Excel! In this post, we will explore three different ways to join or combine text values in Excel. Whether you want to use Flash Fill, concatenation, or the TEXTJOIN function, we will cover them all. So let’s get started! Video Step-by-step Tutorial The objective of this tutorial…Read More
Long lists of data can be time-consuming to enter in Excel. Here’s how to use the Excel fill handle to save yourself hours of work!Read More
Flash Fill is a marvelous feature that is designed to fill values down based on an example in an adjacent column. That is, you have a column of values and then you enter an example of a derived value in an adjacent column. Flash Fill attempts to recognize the pattern from your example and then…Read More
Do you love FlashFill? Do you love Get & Transform queries? If so, you’ll love the most recent Excel update pushed out by Microsoft: New Column by Example. It is essentially FlashFill inside PowerQuery. It is way cool. Check it out. Objective Let’s say we have some data. It doesn’t matter where it is, it…Read More
Have you ever split one column in to many columns, or vice versa, combined many columns into a single column? If so, you have likely relied on the text-to-columns feature to split a single column into many and the CONCATENATE function to join many columns into a single column. Beginning with Excel 2013, Microsoft provides…Read More