Converting Text to a Table using "Fixed Width Text to Columns" in Microsoft Excel

in Threespeak2 months ago

▶️ Watch on 3Speak

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:!As32ynv0LoaIiLo_c7R8XW5XoqtMfw?e=DXytNP

Related Videos:

Remove Trendline from the Legend in Microsoft Excel:
Trendline Slope and Intercept Formulas in Microsoft Excel:
ISERROR and ISERR Functions in Microsoft Excel:
Transparent Images in Microsoft Excel + Useful Tip:
Convert Time to number, seconds, hours and minutes in Microsoft Excel 2007:
Converting Numbers to Fractions in Microsoft Excel 2007:
Intro to Tables in Excel 2007:
Drop Down Lists with Microsoft Excel 2007:
Numbered Headings and Automated Table of Contents - Office Word 2007:
Microsoft Excel Tips: -22 = +4 and NOT -4!!!:
Skip Blanks when Graphing in Microsoft Excel:
Automate Formulas using INDIRECT() Function in Excel: .


DONATE! ʕ •ᴥ•ʔ

Like, Subscribe, Favorite, and Comment Below!

Follow us on:

Official Website:
Email me: [email protected]

Try our Free Calculators:

BMI Calculator:
Grade Calculator:
Mortgage Calculator:
Percentage Calculator:

Try our Free Online Tools:

iPhone and Android Apps:

▶️ 3Speak


Upvoted by GITPLAIT!

We have a curation trial on you can earn a passive income by delegating to @gitplait
We share 80 % of the curation rewards with the delegators.

To delegate, use the links or adjust 10HIVE, 20HIVE, 50HIVE, 100HIVE, 200HIVE, 500HIVE, 1,000HIVE, 10,000HIVE, 100,000HIVE

Join the Community and chat with us on Discord let’s solve problems & build together.