Trimming a text Field with a text formula

I am trying to create a report link that matches (Source Field to Target Field) respective Concatenated Text fields. This is what a typical result looks like: 86505-23-2020 06:06 AM . I need to create...