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.
TRANSPOSE
Breaking apart long strings of data into separate cells is a common task in Excel—and with the TEXTSPLIT function, we have an incredibly powerful and flexible tool to do just that. In this post, we’ll explore how TEXTSPLIT can help us split data into columns, rows, or both—all from a single cell entry! Video What…
This is the third and final post in the PivotTable Text Values Alternative series, where we are discussing alternatives to displaying text values in PivotTables. In the first post, we used Power Query as an alternative. In the second post, we combined multiple text values. In this post, we’ll use the FILTER function as an…