Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Split Data into Different Columns Using Flash Fill in Excel

Date:2019-8-29 Author:Cordelia

Making a table in Excel requires you to put different types of data in different columns. But sometimes the data collected by others or uploaded from a TXT file may not be organized that well. You can of course split the data in a column into different columns manually by cutting and pasting. But if there’re tons of data waiting to be processed, you must want an easier way to save time and effort. I’ve introduced the method to split a column through Text to Columns in previous post, here I’d like to share another way using Flash Fill.

In this table below, all the data are stored in column A which looks very messy. They can obviously be divided into three types: serial number, name and score. To split the data in column A to column B-D separately, the first thing you should do is giving Excel an example.

How to Split Data into Different Columns Using Flash Fill in Excel

Enter the first data of the first row in B2, which is “1“.

How to Split Data into Different Columns Using Flash Fill in Excel

Put the cursor at the bottom-right corner of B2 and drag your mouse to select all the cells in column B. Thus you can auto fill the selected cells with fill handle.

How to Split Data into Different Columns Using Flash Fill in Excel

Then click the icon of Auto Fill Options on the lower-right corner and select Flash Fill in the drop-down list.

How to Split Data into Different Columns Using Flash Fill in Excel

This column will automatically be filled with the same type of data as “1” in column A.

How to Split Data into Different Columns Using Flash Fill in Excel

Similarly, you can enter “Nick” in C2 and use Flash Fill to enter all the names in column C; enter “70” in D2 and auto fill all the cells in column D with the scores.

How to Split Data into Different Columns Using Flash Fill in Excel

In this way you can easily split the text in a column into different columns no matter how much the data is.

How to Split Data into Different Columns Using Flash Fill in Excel
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

1 thought on “How to Split Data into Different Columns Using Flash Fill in Excel”

  1. mobile legends hack skin 2019 says:

    Hey! I know this is somewhat off topic but I was wondering if you knew where
    I could locate a captcha plugin for my comment
    form? I’m using the same blog platform as yours and I’m having difficulty
    finding one? Thanks a lot!

Leave a Reply

Your email address will not be published. Required fields are marked *