Forum Discussion
Excel Template That Fills in Blanks in a .txt file
Thank you for this information. I have attached the text file that I am trying to ultimately edit via Excel. The fields that I would like to replace via the Excel template are filled in with "XXXXXXXX." As you can see, they are whole lines of text so I'm not sure how I would be able to have Excel fill in just those spots. If I made them their own cells, I could do it but I don't know if I'd still be able to export it to a text file and have it still retain the proper formatting.
I had to convert the text file to pdf so that I could attach it to this comment.
Ahhh....your initial description sounded nothing like this.
One of my questions at the start (I deleted it before I posted my initial response) was to ask whether or not Excel is actually what you needed.
Now that I see this, I don't see any specific reason for excel to be used.... so let me ask: why not import to MS Word where you can, I believe, use "Search and Replace" or maybe it's called "Find and Replace" to find the fields in question. And I think you could export or "Save As..." a txt file.