zakruti.com » Knowledge, science, education » Technology for Teachers and Students

Combining Excel Data by using TEXTJOIN or Flash Fill

video description

Rating: 4.0; Vote: 1

Learn how to combine data from all across an Excel spreadsheet. You'll see two different methods of doing this: one method using the Flash Fill tool, and the other using the TEXTJOIN function. Each is useful in different scenarios
Date: 2022-04-08

← Creating a Family Budget with Excel

Create an Excel Macro from Scratch: AutoFit Columns →

Related videos

Josh Johnson Answers The Web's Most Searched Questions

• WIRED

This Weird Motor saved me 3500!

• GreatScott!

Crimea Situation Is Insane

• RealLifeLore

The Entire History of Ancient Greece (3000 BC - 146 BC) - Full Documentary

• Knowledgia

You Are Alive to Watch the Solar System's Greatest Storm Die

• What If

Nightmares of the North: Australia’s Deadliest Wildlife - Extra Long Documentary

• Get.Factual

Comments and reviews: 2

Christian
I use the texjoin function a lot, just like you show in this video (including 'paste special' + 'values'); but now I learned the more powerful system FlashFill. It will help me a lot in the future. Thank you very much.
reply

Anderson
Flash Fill is great. However, for textjoin, we can use alternative way by using 1) Concatenate or 2) -&- plus - - to join different cells together.
reply

Add a review, comment