Use the Text to Columns Feature
4,759 views · Published 1 May 2011 · 2:57 · Indexed 6 October 2026
Channel: Doug H · 2011 · Education
Text to Columns is one of those "hidden" features that's extremely useful when you get files that are combined in cells. Usually it coming from other systems that combine values either with commas, tabs or spaces all in one cell and having the text to columns feature helps to split or separate those out. See the video demo on how to use the Text to Columns feature in Excel 2007 . 🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p 🏫 Excel Training ➜ https://www.exceltraining101.com/p/training.html 📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough ⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53 ⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G ⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101 📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support! 🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough #excel #msexcel #doughexcel -~-~~-~~~-~~-~- Please watch: "Convert Table in a PDF File to Excel" https://www.youtube.com/watch?v=COUOvhbQ4CQ -~-~~-~~~-~~-~-
More from this channel
-
2:58
Use the MIN and MAX Functions
-
9:33
How to Use Excel Table Features for Efficient Data Management
-
3:13
Protect a Worksheet
-
3:18
Use File Protection
-
2:12
Discover the Excel AutoCalculate Hack: Boost Your Spreadsheet Skills
-
3:39
Create a Line Chart with Picture Markers
-
1:36
Excel Hack: Say Goodbye to Duplicate Records Forever
-
1:56
Create a Chart with One Keyboard Shortcut