Click to copy, then share by pasting into your messages, comments, social media posts and websites.
Click to copy, then add into your webpages so users can view and engage with this video from your site.
Report Content
We also accept reports via email. Please see the Guidelines Enforcement Process for instructions on how to make a request via email.
Thank you for submitting your report
We will investigate and take the appropriate action.
Converting Text to a Table using "Fixed Width Text to Columns" in Microsoft Excel
When I was writing my thesis I needed to prepare data tables from text files so I needed a way to convert text to tables in Microsoft Excel. I already knew how to use the Delimited Text to Columns option but the data I was using is all separated by a space except some numbers had a negative number. The negative sign messed up the data so the Delimited option does not work. But Microsoft Excel actually has a pretty amazing "Fixed Width Text to Columns" option which allows to make custom columns and for most types of data this should work. This is an extremely important concept to learn so make sure to watch this video as it will save you a lot of time and effort when dealing with large amounts of data!
Download the notes in my video: https://1drv.ms/x/s!As32ynv0LoaIiLo_c7R8XW5XoqtMfw?e=DXytNP
Related Videos:
Remove Trendline from the Legend in Microsoft Excel: http://youtu.be/njp-zx_5Dq0
Trendline Slope and Intercept Formulas in Microsoft Excel: http://youtu.be/DTDY9RL35b8
ISERROR and ISERR Functions in Microsoft Excel: http://youtu.be/MrZLtpsLktM
Transparent Images in Microsoft Excel + Useful Tip: http://youtu.be/uKjtsQZ5Ow0
Convert Time to number, seconds, hours and minutes in Microsoft Excel 2007: http://youtu.be/fwMKbXI98tI
Converting Numbers to Fractions in Microsoft Excel 2007: http://youtu.be/YgJBK0QjIec
Intro to Tables in Excel 2007: http://youtu.be/B_zXmunqrl4
Drop Down Lists with Microsoft Excel 2007: http://youtu.be/e7Sbcn-y9j4
Numbered Headings and Automated Table of Contents - Office Word 2007: http://youtu.be/e00xCQ0MClg
Microsoft Excel Tips: -2^2 = +4 and NOT -4!!!: http://youtu.be/9QC3ZboI3wo
Skip Blanks when Graphing in Microsoft Excel: http://youtu.be/HcCJVUd7a5Q
Automate Formulas using INDIRECT() Function in Excel: http://youtu.be/9WiBtrNq9yU .
------------------------------------------------------
SUBSCRIBE via EMAIL: https://mes.fm/subscribe
DONATE! ʕ •ᴥ•ʔ https://mes.fm/donate
Like, Subscribe, Favorite, and Comment Below!
Follow us on:
Official Website: https://MES.fm
Hive: https://peakd.com/@mes
Gab: https://gab.ai/matheasysolutions
Minds: https://minds.com/matheasysolutions
Twitter: https://twitter.com/MathEasySolns
Facebook: https://fb.com/MathEasySolutions
LinkedIn: https://mes.fm/linkedin
Pinterest: https://pinterest.com/MathEasySolns
Instagram: https://instagram.com/MathEasySolutions
Email me: [email protected]
Try our Free Calculators: https://mes.fm/calculators
BMI Calculator: https://bmicalculator.mes.fm
Grade Calculator: https://gradecalculator.mes.fm
Mortgage Calculator: https://mortgagecalculator.mes.fm
Percentage Calculator: https://percentagecalculator.mes.fm
Try our Free Online Tools: https://mes.fm/tools
iPhone and Android Apps: https://mes.fm/mobile-apps
Category | Science & Technology |
Sensitivity | Normal - Content that is suitable for ages 16 and over |
Playing Next
Related Videos
Graphing a Hyperboloid of One Sheet in 3D
20 hours ago
Graphing a Hyperbolic Paraboloid in 3D
2 days, 2 hours ago
MES Livestream 9: Freedom Activist Allen Forrest Joins the Show
2 days, 18 hours ago
Graphing an Elliptic Paraboloid in 3D
3 days, 2 hours ago
Proof that Sum of Angles in ANY Triangle = 180 degrees
4 days, 3 hours ago
1 week ago
Warning - This video exceeds your sensitivity preference!
To dismiss this warning and continue to watch the video please click on the button below.
Note - Autoplay has been disabled for this video.