Combining Excel Data by using TEXTJOIN or Flash Fill
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- 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. My entire playlist of Excel tutorials: bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's the practice file that goes with this video: bit.ly/exceltex... #exceltutorial #excel
I'm so grateful to be learning excel with the best. I just can't miss any of you videos. God bless you enormously!
Hello
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.
tHANK YOU, from philippines
Just an fyi, no need to create the new column. Simple copy and then paste as values directly over the same column.
Great information! I have learned so much from you!
Flash Fill is great. However, for textjoin, we can use alternative way by using 1) Concatenate or 2) "&" plus " " to join different cells together.
Thanks so much I really appreciate these tutorials
Thank you so much. You are a big help in my future. I wish to give back to you someday :)
good job
Extremely helpful, tfs
"Nice and creative Videos，I can see A lot of thought has been put into the content and editing of the video， This is really my favorite channel.:) .🌴🌴🌴excellent 👍👌👍👌👍 🌴🌴🌴 🌴🌴🌴 🌴🌴🌴 🌴🌴🌴. Gainesville , Virginia , 2021
You don't have to create a whole new column just to paste values. You can just copy and past values in the exact same column and it'll still take out the formula.
ALWAYS GREAT MANY THANKS
LOVE your Channel.
Leaving Big Tech Tyrant.
Are you on Gab? MeWe? Bitchute? Odysee? Rumble?
Anywhere FREE of Censorship??
Thank you for sharing your work
Great 💫
🍎pay