Forum Discussion

Kim and Warren Perkins's avatar
Kim and Warren Perkins
Copper Contributor
Jun 22, 2018

Pulling data from extracted powerpoint slides

Hi, I am a excel user with just basic skills and knowledge.  I have data that is extracted from powerpoint slides into excel and I am attempting to easily isolate the specific data I need to research.  I would need to search for the term PAR and then copy the preceding data (25 spaces) and have it displayed in the following manner.

 

567891011, 1EA, XXX XXX, PAR

123456789, 3EA, XXX XXX, PAR

 

5678910111EAPAR
1234567892EAPAR

 

Macros & VBA
Tutorial

4 Replies

    • Kim and Warren Perkins's avatar
      Kim and Warren Perkins
      Copper Contributor
      Jun 23, 2018

      I can't get flash fill to work.  Sorry, I also identified another issue, there are multiple part numbers in each row of data.

      Extracted data from powerpointdesired output
      Countertop mixer, 1234567891234, 1EA, XXX XXX, PAR, XXX 23JUN18, XXXXXXXXXX, XXXX XXX Smoothie mixer, 5678912345678, 1EA, XXX XXX, PAR, XXX 25JUN18, 000000000, XXXX XXX 1 Food processor, 567778888, 2EA, XXX XXX, PAR, XXX 20JUN18, XXXXXXXXXXXXXX, XXXX XXX567891234 912345678 567778888
      Meat grinder, 456875332, 4EA, XXX XXX, PAR, XXX 23Sep18, XXXXXXXXXXXXXX, XXXX XXX meat slicer, 1536028627841, 1EA, XXX XXX, PAR, XXX 25JUN18, 000000000, XXXX XXX 1 XXX Cheese grater, 986217538, 1EA, XXX XXX, PAR, XXX 25JUN18, 000000000, XXXX XXX 1456875332 028627841 986217538
      • Marvin Oco's avatar
        Marvin Oco
        Steel Contributor
        Jun 24, 2018

        you can try the following:

         

        1. paste the data in a notepad as save as csv file (save as .csv instead of .txt)

        2. open the csv file in excel and use the concatenate formula

         

        =CONCATENATE(I2,P2)

         

        see attached sample