Removing character from Text field
I have a text field [Field A]. I would like to create a text formula field [Field B] that removes the character "-" from [Field A] if [Field A] contains the character "-". [Field A] = "abc-d" [Fie...
Forum Discussion
Another way to avoid doubling up of text:
If(not Contains([field],"-"), [field],
Left([field],"-")& Right([field],"-"))
If(not Contains([field],"-"), [field],
Left([field],"-")& Right([field],"-"))
