Hello,
Can someone please help me with the following formula?
Example: Account = Customer One-OR
Exampe: Account Name 2 = Customer One
I have created a custom field called Account Name 2. I need to first identify if the "Account" field's text string has a "-" as the 3rd character from the end. If it does, I need to set the Account Name 2 field = Account name field - the last three characters (so in this example remove the "-OR", and if formula does not have 3rd character from the end = "-", then set the Account Name 2 with the full Account name field.
Thank you in advance for any help.
Best Regards,
Kim
8 respuestas
AHHHH!!! Sorry, my bad... here you go
IF(MID( Name , LEN(Name) - 2, 1) = "-",
LEFT(Name , LEN(Name) - 3),
Name)
Is this the result you're looking for?
