7 Replies Latest reply: Oct 27, 2016 6:19 PM by juan prado RSS

    Separate String

    juan prado

      Hey guys!

       

      I need your help, again!...

       

      I have an excel file with one column with strings like this:

       

      0A001101068646800000200000001665744520160601000000000000000000000016657445000000000000000000684

      1A001101068646800000000000000000000000000000075657VARA, NICOLAS MARIANO3279

      2A001101068646900000000000000000000000000000080804FRECHA, MARIA EMILIA3280

      3A001101068647000000000000000000000000000000053208PLUGOBOY, MARIA DEL CARMEN3281

      424A001101068689100000000000000000000000000000115142ABBATE, GONZALO EMANUEL7243

      427A001101068689400000000000000000000000000000004296MARIN, FACUNDO LUCIANO7256

      587A001101068705400000000000000000000000000000077563GUGLIOTA, NATALIA MARCELA8846

       

      I need to separate this info in two columns like this

       

      Header 1Header 2
      VARA, NICOLAS MARIANO75657
      FRECHA, MARIA EMILIA80804
      PLUGOBOY, MARIA DEL CARMEN53208
      ABBATE, GONZALO EMANUEL115142
      MARIN, FACUNDO LUCIANO4296
      GUGLIOTA, NATALIA MARCELA77563

       

      Thanks for your help!