Remove a string of characters after a special charater :

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)

Find more posts tagged with

Accepted answers

You need to put it in a different column.

All comments

Try this:

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

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.

You need to put it in a different column.

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

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.