Forum Discussion

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...

Macros & VBA

Tutorial

Marvin Oco

Steel Contributor

Jun 22, 2018

you can paste the data in excel and use flash fill to extract/arrange the data that you want
https://support.office.com/en-us/article/using-flash-fill-in-excel-3f9bcf1e-db93-4890-94a0-1578341f73f7

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 powerpoint	desired 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 XXX	567891234 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 1	456875332 028627841 986217538

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
- Kim and Warren Perkins
  Copper Contributor
  Jun 26, 2018
  Notepad won't let me save as csv only txt. Thanks for the suggestion, however, I obtained another solution.