Excel column separation of data in single cell











up vote
-2
down vote

favorite












I have copy and pasted data into an Excel worksheet that includes each column's value in the first cell only. How can I separate these into their own cells for later calculations without manually doing 1 at a time, since there are 1,200+ cell values. I have included a screenshot of my current issue.



Excel screenshot










share|improve this question









New contributor




S. Crockett is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
















  • 3




    Text to Columns.
    – BruceWayne
    Nov 5 at 18:02












  • You go to Data>>Text To Columns and choose Fixed Width
    – JNevill
    Nov 5 at 18:02












  • thank you so much
    – S. Crockett
    Nov 5 at 20:19















up vote
-2
down vote

favorite












I have copy and pasted data into an Excel worksheet that includes each column's value in the first cell only. How can I separate these into their own cells for later calculations without manually doing 1 at a time, since there are 1,200+ cell values. I have included a screenshot of my current issue.



Excel screenshot










share|improve this question









New contributor




S. Crockett is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
















  • 3




    Text to Columns.
    – BruceWayne
    Nov 5 at 18:02












  • You go to Data>>Text To Columns and choose Fixed Width
    – JNevill
    Nov 5 at 18:02












  • thank you so much
    – S. Crockett
    Nov 5 at 20:19













up vote
-2
down vote

favorite









up vote
-2
down vote

favorite











I have copy and pasted data into an Excel worksheet that includes each column's value in the first cell only. How can I separate these into their own cells for later calculations without manually doing 1 at a time, since there are 1,200+ cell values. I have included a screenshot of my current issue.



Excel screenshot










share|improve this question









New contributor




S. Crockett is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











I have copy and pasted data into an Excel worksheet that includes each column's value in the first cell only. How can I separate these into their own cells for later calculations without manually doing 1 at a time, since there are 1,200+ cell values. I have included a screenshot of my current issue.



Excel screenshot







excel






share|improve this question









New contributor




S. Crockett is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




S. Crockett is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited Nov 5 at 20:12









TotsieMae

800417




800417






New contributor




S. Crockett is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked Nov 5 at 18:01









S. Crockett

11




11




New contributor




S. Crockett is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





S. Crockett is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






S. Crockett is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.








  • 3




    Text to Columns.
    – BruceWayne
    Nov 5 at 18:02












  • You go to Data>>Text To Columns and choose Fixed Width
    – JNevill
    Nov 5 at 18:02












  • thank you so much
    – S. Crockett
    Nov 5 at 20:19














  • 3




    Text to Columns.
    – BruceWayne
    Nov 5 at 18:02












  • You go to Data>>Text To Columns and choose Fixed Width
    – JNevill
    Nov 5 at 18:02












  • thank you so much
    – S. Crockett
    Nov 5 at 20:19








3




3




Text to Columns.
– BruceWayne
Nov 5 at 18:02






Text to Columns.
– BruceWayne
Nov 5 at 18:02














You go to Data>>Text To Columns and choose Fixed Width
– JNevill
Nov 5 at 18:02






You go to Data>>Text To Columns and choose Fixed Width
– JNevill
Nov 5 at 18:02














thank you so much
– S. Crockett
Nov 5 at 20:19




thank you so much
– S. Crockett
Nov 5 at 20:19












1 Answer
1






active

oldest

votes

















up vote
0
down vote













There are many ways to do this.



You can us Data / Text To Columns and split either on fixed width or you can use a space as the delimeter and tell it to treat multiple as single.



You could use a formula using the mid function and trim functions to split out that way.



You could use code using the split function.



SO isn't a volunteer coding site however, it's a learning site so give one of these ideas a go and if you get stuck post back with an example of what you have tried and we will explain what went wrong.






share|improve this answer





















    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });






    S. Crockett is a new contributor. Be nice, and check out our Code of Conduct.










     

    draft saved


    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53159788%2fexcel-column-separation-of-data-in-single-cell%23new-answer', 'question_page');
    }
    );

    Post as a guest
































    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    0
    down vote













    There are many ways to do this.



    You can us Data / Text To Columns and split either on fixed width or you can use a space as the delimeter and tell it to treat multiple as single.



    You could use a formula using the mid function and trim functions to split out that way.



    You could use code using the split function.



    SO isn't a volunteer coding site however, it's a learning site so give one of these ideas a go and if you get stuck post back with an example of what you have tried and we will explain what went wrong.






    share|improve this answer

























      up vote
      0
      down vote













      There are many ways to do this.



      You can us Data / Text To Columns and split either on fixed width or you can use a space as the delimeter and tell it to treat multiple as single.



      You could use a formula using the mid function and trim functions to split out that way.



      You could use code using the split function.



      SO isn't a volunteer coding site however, it's a learning site so give one of these ideas a go and if you get stuck post back with an example of what you have tried and we will explain what went wrong.






      share|improve this answer























        up vote
        0
        down vote










        up vote
        0
        down vote









        There are many ways to do this.



        You can us Data / Text To Columns and split either on fixed width or you can use a space as the delimeter and tell it to treat multiple as single.



        You could use a formula using the mid function and trim functions to split out that way.



        You could use code using the split function.



        SO isn't a volunteer coding site however, it's a learning site so give one of these ideas a go and if you get stuck post back with an example of what you have tried and we will explain what went wrong.






        share|improve this answer












        There are many ways to do this.



        You can us Data / Text To Columns and split either on fixed width or you can use a space as the delimeter and tell it to treat multiple as single.



        You could use a formula using the mid function and trim functions to split out that way.



        You could use code using the split function.



        SO isn't a volunteer coding site however, it's a learning site so give one of these ideas a go and if you get stuck post back with an example of what you have tried and we will explain what went wrong.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 5 at 20:17









        Dan Donoghue

        4,4731530




        4,4731530






















            S. Crockett is a new contributor. Be nice, and check out our Code of Conduct.










             

            draft saved


            draft discarded


















            S. Crockett is a new contributor. Be nice, and check out our Code of Conduct.













            S. Crockett is a new contributor. Be nice, and check out our Code of Conduct.












            S. Crockett is a new contributor. Be nice, and check out our Code of Conduct.















             


            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53159788%2fexcel-column-separation-of-data-in-single-cell%23new-answer', 'question_page');
            }
            );

            Post as a guest




















































































            這個網誌中的熱門文章

            Tangent Lines Diagram Along Smooth Curve

            Yusuf al-Mu'taman ibn Hud

            Zucchini