I’m using a formula to concatenate different dates an area was worked on as the record ID. In one tab I have all the offices and all of the associated data with them, and in the other I have a submissions page that’s linked to the office page. My problem is some of them concatenate as “AreaName” - Date and others are AreaName - Date. I have attached some screenshots for a visual.
I believe TRIM() will only work for spaces. Last time a client of mine had this problem with quotation marks, there were lots of invisible characters of some sort (that weren’t considered spaces) that were causing this problem.