Excel spreadsheet task (looking up an external .txt file)
- or -
Post a project like this4017
$$
- Posted:
- Proposals: 19
- Remote
- #236616
- Completed
Automation Expert,web designer,SEO Practitioner, Oracle PL/SQL developer, Windows desktop app developer(C#, sql server)
Stanmore
Microsoft ASP.Net, C#, Deskto application and Web developer. Office application expert.
Scarborough
39168343274342815642775742621442542842447042063039922149918385411
Description
Experience Level: Intermediate
probably quite simple excel task. I have a spreadsheet with a column full of cells that reference a small text file (.txt).
I want something written that:
1) For each cell in a column, it looks up the .txt file in a specific folder
2) Returns the contents of the text file (it just has a sentence or two of text)
JUST TO CLARIFY.......
The actual spreadsheet is 25,000 rows. In the example attached I want C2 to show the contents of the text file that is referenced to in D2 (34894.txt is a text file). All the text files are in one folder. the text files just contain a sentence or paragraph of text.
Paul
I want something written that:
1) For each cell in a column, it looks up the .txt file in a specific folder
2) Returns the contents of the text file (it just has a sentence or two of text)
JUST TO CLARIFY.......
The actual spreadsheet is 25,000 rows. In the example attached I want C2 to show the contents of the text file that is referenced to in D2 (34894.txt is a text file). All the text files are in one folder. the text files just contain a sentence or paragraph of text.
Paul
Paul S.
100% (28)Projects Completed
24
Freelancers worked with
27
Projects awarded
28%
Last project
17 Aug 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies