Results 1 to 4 of 4

Thread: decompose data

  1. #1

    decompose data



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello! I need to decompose the following data (35.0 ; 11.0 ; 129.0 ) that I have in a cell to different cells where 35 , 11, and 129 are the code and 0 is any value of each code and it will be in another cell and the ";" is the separator ; thank you.
    Attached Files Attached Files

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by jimztercrack View Post
    value of each code and it will be in another cell and the ";" is the separator
    Try

    Select cell A1
    Tab Data => Command Text to Columns
    Delimited option => Next button
    Choose Semicolon option
    Command Finsih button
    Transpose Row 1 to Column
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3

    decompose data automatically

    Thanks, but I need to update the data automatically I mean the data in cell A1 is going to change for that I need a Function that take the data from cell A1 constantly
    Attached Files Attached Files

  4. #4
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013

    Extract number before specific character

    Quote Originally Posted by jimztercrack View Post
    I need a Function that take the data from cell A1 constantly
    Try this ARRAY formula with extra columns
    Code:
    =IFERROR(INDEX($Q$2:$Q$300;MATCH(0;COUNTIF($S$1:S1;$Q$2:$Q$300);0));"")
    see example
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •