Remove a string of characters after a special charater :

keesuri25

Need a formula to remove "Account name" from the Use case name. Right now the format in the use case column is Account Name: Use case Name

I want the "use case column" to only have the use case.

I tried the below formula but getting a circular reference error. Please advice. Thank you.

=LEFT([Use case: Name]@row + ":", FIND(":", [Use case: Name]@row + ":") - 1)

Paul Newcome

You need to put it in a different column.

Paul Newcome

Try this:

=RIGHT([Account Name]@row, LEN([Account Name]@row) - (FIND(":", [Account Name]@row) + 1))

keesuri25

Screen Shot 2022-11-08 at 12.13.05 PM.png

Screen Shot 2022-11-08 at 12.13.17 PM.png

Getting the same error. Circular Reference and Blocked.

Paul Newcome

You need to put it in a different column.

keesuri25

Gosh ! Should have thought of that .. Thank you.

Paul Newcome

Happy to help. 👍️