seperate data in excel

Posted on 2011-10-19
Last Modified: 2012-05-12

I have a set of data coming in this format
09 FD 7E 00 02 00 00 02 12 11 C2 00 00 01 7D 00
how can i seperate them in individual columns in excel like the one i have attached?
Question by:csharp_learner
    LVL 43

    Assisted Solution

    by:Saqib Husain, Syed
    Data > Text to columns > Delimited >
    Select space as delimiter
    Continue with dialog

    Author Comment

    can you show me on the attached example?
    LVL 26

    Accepted Solution

    Hi, csharp_learner.

    Please see attached (using Mid() in formulas).

    I assumed that you wanted leading and trailing blanks dropped, but this is easily changed, if necessary.

    Brian seperate-V2.xls
    LVL 26

    Expert Comment

    Thanks, csharp_learner!
    LVL 43

    Expert Comment

    by:Saqib Husain, Syed
    Oh I did not see your file.

    In this case you need a fixed width option instead of a delimited option. See demo.

    BTW while this file was uploading you had already accepted the solutions. You did not have to accept mine as it was not precisely what you wanted. This demo is good for either a one-time run or a separation which varies frequently. For a defined separation you should go ahead with Brian's solution.


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now