Forum Discussion
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...
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
https://support.office.com/en-us/article/using-flash-fill-in-excel-3f9bcf1e-db93-4890-94a0-1578341f73f7
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 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
Notepad won't let me save as csv only txt. Thanks for the suggestion, however, I obtained another solution.
