Hi,
With a tiny bit of effort, the below will speed things up for you. I use this every day, pretty much, to create a selections file for my triggers.
With reference to the attachments.
One is a screen shot of what the spreadsheet looks like should you wish to recreate it.
I have also attached a copy of the spreadsheet I created for you to use directly.
The formulae assume the list of names are in Col C, starting at C3
Cell H3 formula =CONCAT("~",C3,"~")
This puts ~ either side of the name
Cell G3 formula =REPLACE(H3,1,1,"""")
This replaces the first ~ with double quotes
Cell F3 formula =REPLACE(G3,FIND("~",G3),1,"""")
This replaces the second ~ with double quotes
Cell E3 formula =IFERROR(REPLACE(F3,FIND("'",F3),1,""),F3)
This removes any single quotes as sometimes found in horse names
e.g. King's Advice becomes Kings Advice
Why? Because MFP won't accept ' in a text file selection's name!
Select and drag the formulae from row 3 down as needed.
All the names now in column E (highlighted in grey) can be selected in en-masse and pasted into a text file.
Hope that helps,
regards
Wez