From the course: Excel: Advanced Formulas and Functions
Join today to access over 23,200 courses taught by industry experts.
TEXTBEFORE and TEXTAFTER
From the course: Excel: Advanced Formulas and Functions
TEXTBEFORE and TEXTAFTER
- [Instructor] This is exciting, but it's, wow. Hopefully you have this. The dynamic arrays are relatively new in Excel, and the team keeps putting out more and more functions. Here is one of the newer ones, and it's so cool. I hope that you can avail yourself of this coolness. So here is some data, and let's say we got this data, and on the webpage, it was all nice and separated. We had this person's ID, that they're a local person instead of remote, they're in healthcare, they rent, they don't own, their favorite color is orange, their assignment is TJ, and this person is a Libra. And we go down here, this person is another renter, a Virgo, favorite color purple, et cetera. So we want a couple of things. Over, in column C, we want to extract the profession. And then, starting in row 12, we only want the favorite color, the assignment, and the zodiac sign, but still all in one cell. What do you want to do first? Yeah, all…
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.