Expert Office Training

The Fastest, Easiest Way to become an Office Guru!

 

 

 

  • Home
  • Master Classes
    • Become an Excel Guru – Master Training – Get your Dream Job!
    • Learn Microsoft Word 2016 – From Beginner to Expert
    • Master Excel Formulas Tips & Tricks
    • Access for Excel – Manage Data & Create Amazing Excel Reports
    • Learn Microsoft Powerpoint 2016 – From Beginner to Expert
  • Free Video Tips & Tricks
  • Contact
  • Recommended Products & Services

Microsoft Excel – Text to Columns – Learn How to use this Great Function using Real-World Examples

August 24, 2017 By Scott

Text to Columns the easiest way to add data to an excel worksheet is by opening a file directly in excel. Say each month you get a report electronically, and each month you want to layer the next report onto the report with the prior month’s reports. In month one you would open the original file in excel save and you would be done. In month two you would open month two’s file and copy and paste the data directly into next empty rows in the spread containing month one. So each month you save in the same file one right after the other. So rows 1-100 are January, 101-200 are February… etc.

This is quite basic and may seem easy to you if your familiar with opening files in excel. The monkey wrench arises when you have a file that’s in a different format than excel. Usually CSV “Comma Separated Value” file or a plain text (.txt) file. These files usually need a little manipulation to open in the most usable format. This is where text to columns comes in very handy. Text to columns allows us to parse data in many ways. (Divide a string of data into smaller parts in multiple cells). It allows us to parse the data by choosing a fixed width (if every row of data is equal and the breaks would always be the same) or we can delimit our data by various factors (split the data at every comma, semicolon, period space or any character that you need to delimit the data)

Let’s look at some examples in the video above.

Filed Under: Excel, Microsoft Office Tagged With: Excel, Formulas, Microsoft Office

Get Your FREE Video Course Now!!

* indicates required

Get Your FREE Video Course Now!

Enter your email to get my FREE video training delivered right in your inbox!

Tags

Excel Formulas Microsoft Office

Recent Posts

  • Microsoft Excel – Text to Columns – Learn How to use this Great Function using Real-World Examples
  • Date Formula in Microsoft Excel – Learn how to Easily Format Dates
  • Excel FILTER – Multiple ways to use filters in Microsoft Excel in the Real-World
  • Microsoft Excel TRIM Formula – Remove all leading and trailing spaces in Excel
  • CONCATENATE – Merge Data from Different Cells into One Cell in Excel

New Developments

In the works, courses and videos covering the following: Microsoft Access Microsoft Outlook Microsoft One Note WordPress Installs Selling Online Hosting Amazon Web Services … Read more

Our Latest Tips & Tricks

Microsoft Excel – Text to Columns – Learn How to use this Great Function using Real-World Examples

August 24, 2017

Date Formula in Microsoft Excel – Learn how to Easily Format Dates

August 24, 2017

Excel FILTER – Multiple ways to use filters in Microsoft Excel in the Real-World

August 24, 2017

Connect With Us

  • Facebook
  • Twitter
  • YouTube
  • Home
  • About
  • Contact

Copyright © 2025 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in