Avatar of Alex Krakov
Alex Krakov

asked on 

Copy previous lines from a specific string in a text file and paste them to Excel cell.

I have a text file, its look like...

word 1


word 2


word 3


I want to find all the strings "Line" in a text file, and copy the previous line (word 1, word 2, word 3) before "Line" and paste them into Excel cells. Please suggest.
Microsoft OfficeVBAMicrosoft Excel

Avatar of undefined
Last Comment
Alex Krakov

8/22/2022 - Mon