Forum Discussion

Roy_lavi's avatar
Roy_lavi
Copper Contributor
May 01, 2019
Solved

moving multiple values in the same cell to a new one

Hello

I have a long list (column) of multiple values and I am looking for an easier way to cut one value or more to another cell.

In other words, I need to seperate two or more values from the same cell so that each value has it's own cell.

for example

I have this short list with two or more values in each cell 

148,111
42,43,56
77,121
44,45,74
66,109,84
79,65,95
42,101,130

 and I want to make it like this

148111 
424356
77121 
444574
6610984
796595
42101130

 

of course, with out cutting and pasting....

 

thanks allot!

 

Roy

  • Roy_lavi's avatar
    Roy_lavi
    May 01, 2019

    Celia_Alves 

     

    Hi, it worked well on most cells, thanks!

     

    I wonder what is different in the cells it did not work on

     

     

18 Replies

  • Roy_lavi 

    Select your column

    Go to Tab Data

    Click button "Text to Columns" (on Data Tools group)

    On the dialogue box that pops up, choose "Delimited"

    click Next

    put a checkmark in "comma" (only)

    click next

    Click Finish

     

    Let me know if this works. Good luck!

     

     

     

     

    • Roy_lavi's avatar
      Roy_lavi
      Copper Contributor

      Celia_Alves 

       

      Hi, it worked well on most cells, thanks!

       

      I wonder what is different in the cells it did not work on

       

       

      • Roy_lavi 

        I tested here by copying the data from your post and the same happened here. It seems that some of the comas are being interpreted as the thousands separator, and not a text comma. You can see that if you select your column and format as general, or text, or number. 

         

         

Resources