Hi,
I'm looking for a FUNCTION for my task as described below:
- I have numerous text files, and all their filenames/path are in column A
- I want column B to return the first line of the text file (its counterpart in column A), by using a function like =FirstLine(A2)
Is this possible? Thanks! Hoping someone could help me out. Been searching everywhere for this. All I see suggests that I import the text file into excel, which is out of the question, because these te t files are really plenty.
I'm looking for a FUNCTION for my task as described below:
- I have numerous text files, and all their filenames/path are in column A
- I want column B to return the first line of the text file (its counterpart in column A), by using a function like =FirstLine(A2)
Is this possible? Thanks! Hoping someone could help me out. Been searching everywhere for this. All I see suggests that I import the text file into excel, which is out of the question, because these te t files are really plenty.