1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Convert text to excel

Discussion in 'BlackHat Lounge' started by yamahafzr, Feb 11, 2010.

  1. yamahafzr

    yamahafzr Regular Member Premium Member

    Joined:
    Mar 29, 2009
    Messages:
    244
    Likes Received:
    154
    Location:
    NJ
    So I have an enormous list of product ingredients that need to get entered into an excel file. Here is an example two of them.

    Code:
        !Serving Size   4 Capsules       
      Servings Per Container           30        
      Calories           15        
      Protein 3 g       6%*
      Vitamin B-6 (from Pyridoxine HCl)   13 mg  650%
      Proprietary Blend of Amino Acids from Whey Protein Isolate, Soy Protein Isolate, L-Glutamine, L-Arginine, Sodium Caseinate, L-Ornithine and Gelatin (Contains milk and soy proteins)         3.0 g (3,000 mg)          <p>†</p>
                              
      <strong>TYPICAL AMINO ACID PROFILE</strong>                 
      <strong>Essential Amino Acids</strong>     <strong>mg per 4 Capsule Serving</strong> 
      L-Histidine      37 mg  
      L-Isoleucine    115 mg            
      L-Leucine        205 mg            
      L-Lysine          185 mg            
      L-Methionine  35 mg  
      L-Phenylalanine          72 mg  
      L-Threonine    141 mg            
      L-Tryptophan  37 mg  
      L-Valine          141 mg            
      <strong>Non-Essential Amino Acids</strong>                     
      L-Alanine        135 mg            
      L-Arginine      306 mg            
      L-Aspartic Acid          246 mg            
      L-Cysteine      38 mg  
      L-Glutamic Acid         454 mg            
      L-Glutamine    200 mg            
      Glycine            167 mg            
      L-Hydroxyproline       44 mg  
      L-Ornithine     24 mg  
      L-Proline         179 mg            
      L-Serine          106 mg            
      L-Tyrosine       66 mg  
      !Serving Size   4 Capsules       
      Servings Per Container           90        
      Calories           15        
      Protein 3 g       6%*
      Vitamin B-6 (from Pyridoxine HCl)   13 mg  650%
      Proprietary Blend of Amino Acids from Whey Protein Isolate, Soy Protein Isolate, L-Glutamine, L-Arginine, Sodium Caseinate, L-Ornithine and Gelatin (Contains milk and soy proteins)         3.0 g (3,000 mg)          †
      !Serving Size   5 Capsules       
      Servings Per Container           60        
      Calories           10        
      Protein 2 g       4%*
      <strong>PeptoPro® Casein Hydrolysate (milk)</strong>     <strong>2.0 g (2,000 mg)</strong>            <strong>†</strong>
      <strong>TYPICAL AMINO ACID PROFILE</strong>                 
      <strong>Essential Amino Acids</strong>     <strong>mg per 5 Capsule Serving</strong> 
      L-Histidine      42        
      L-Isoleucine    72        
      L-Leucine        150      
      L-Lysine          116      
      L-Methionine  48        
      L-Phenylalanine          80        
      L-Threonine    58        
      L-Tryptophan  14        
      L-Valine          96        
      <strong>Non-Essential Amino Acids</strong>                     
      L-Alanine        46        
      L-Arginine      48        
      L-Aspartic Acid          108      
      L-Glutamic Acid         356      
      Glycine            28        
      L-Proline         166      
      L-Serine          80        
      L-Tyrosine       86        
      
    I have over 1.1k like that. Just copying an pasting that chunk puts them all into different columns/rows. If i want to put one full product in a cell I have to go into the top bar and paste it there. Does anyone know a way to take this list and place every product into 1(ONE!) cell, delimited by the (!) ?

    Thanks
     
  2. jaerehan

    jaerehan Elite Member

    Joined:
    Sep 25, 2009
    Messages:
    1,500
    Likes Received:
    1,504
    Occupation:
    Time...Time is on my side..
    Location:
    EU
    Data (5th tab) text to coloumn, there you can experiment how to do it
     
  3. yamahafzr

    yamahafzr Regular Member Premium Member

    Joined:
    Mar 29, 2009
    Messages:
    244
    Likes Received:
    154
    Location:
    NJ
    Yea i tried that. What is does with that is give them everyline its own cell down column a, then where there is a ! is pushes that line over a column
     
  4. jaerehan

    jaerehan Elite Member

    Joined:
    Sep 25, 2009
    Messages:
    1,500
    Likes Received:
    1,504
    Occupation:
    Time...Time is on my side..
    Location:
    EU
    but thats a bit less work then, i have no other idea sorry
     
  5. yamahafzr

    yamahafzr Regular Member Premium Member

    Joined:
    Mar 29, 2009
    Messages:
    244
    Likes Received:
    154
    Location:
    NJ
    bump it
     
  6. yamahafzr

    yamahafzr Regular Member Premium Member

    Joined:
    Mar 29, 2009
    Messages:
    244
    Likes Received:
    154
    Location:
    NJ
    bump again