I'm having a problem with my Excel File Search Results. See image.
If my Excel file has a Title under File > Info > Properties the Title will show up correctly with the correct link to the file, however in most cases that Title is missing. I'm not having this problem with my PDF or Word documents.
I often end up with two results for the same Excel file, one with the file name but an added "~$" in front of the link making it a broken link.
And the second one has the icon and correct URL but no Title, therefore, making it not clickable.
I understand I can create a new custom Result Type for Excel files but I'm not clear on what those customizations should be in regards to the code, or using a different managed property.
This is an on-prem installation of Sharepoint 2013. I'm including two images. One showing my search results and one showing my prioritized crawled properties on Title.