Join Dennis Taylor for an in-depth discussion in this video Join data with new CONCAT and TEXTJOIN functions, part of Excel Tips Weekly.
- [Voiceover] If you've upgraded Office 365,…in Excel you'll find some additional functions.…If you go to the Formulas tab in the ribbon…and choose the icon Text,…you'll see there's a new function called CONCAT.…Now, some of you might be familiar with a function…called Concatenate, and you might be wondering,…"Where is it?"…Well, it's still available, even though we don't…see this in the list.…This new function will ultimately take the place…of Concatenate.…It can do all the things that Concatenate can do…plus additional capability as well.…
Concatenate's a list or range of text strings.…Farther down the list, you'll see another function…called TEXTJOIN, also new.…Concatenates a list or range of text strings…using a delimiter.…So, we've got a worksheet here with a list of names,…potentially a huge list.…And people have been given IDs.…They're still there.…And we've got a year and a date and a zip here…associated with each person.…We're gonna create a new ID comprised of a…combination of these.…
We want the ID to be, even though it's longer,…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
Freeze Panes and Split New5m 30s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.