Experts, I am concactenating 2 fields. Sometimes a word is duplicated though. In the below, you can see the result of the concactenate and the duplicate: "Monthly - Monthly".
Monthly - Monthly no later than the 10th of the Month.
I need this though: (remove the 2nd occurrance of the word "monthly")
Monthly - no later than the 10th of the Month.
here is the formula in the field:
=[Frequency] & " - " & [timing]
How can I prevent the duplicate? I am looking for simple solution I can use in the field preferably.