From the course: Excel: Managing and Analyzing Data
Join today to access over 24,400 courses taught by industry experts.
Splitting columns with dynamic arrays - Microsoft Excel Tutorial
From the course: Excel: Managing and Analyzing Data
Splitting columns with dynamic arrays
- [Instructor] Let's split some columns with the new dynamic array functions. And here again, is something that I really invite you to explore because there are so much in these functions. Like TOCALL, TEXTSPLIT, TEXTAFTER, TEXTBEFORE. So with this data, we want to split these all into new columns. So let's get this split apart. =TEXTSPLIT , okay? It's going to split text into rows or columns using delimiters. Double click, split this text, comma. split it where? Everything here is split by a space, pipe symbol, space. That has to be in double quotes. Space, pipe symbol, space, double quote. And that's the column delimiter, because I want to split this into columns. Comma, I don't want to split this into rows. Comma, ignore empty cells. I'm going to say FALSE. Include empty cells, why? Because look at the data in row 10 and then 13 and 14. The color of these vehicles is missing. So we want everything to split apart and stay in their respective columns. If we were to ignore those empty…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
