Anyone know what formula to use to remove the links in the export for certain search result columns

I don't think you can have it both. Either don't have the link in the search or get the html-code in the export.

Yeah you can't get the results on the export. I use html coding all the time in searches and have explored this topic too many times and have never found a solution