Calculated column formula to remove unwanted characters

I have a value copied to a text field from a managed metadata column. It is in the following format:

457;#Some text here

How can I remove # and everything else on the left and keep "Some text here" only using a formula in a calculated column?
MisUszatekAsked:
Who is Participating?
 
Jamie McAllister MVPConnect With a Mentor SharePoint ConsultantCommented:
According to the answer referenced below, creating a second calculated column something like this should work;

=RIGHT([Your Calculated Column],LEN([Your Calculated Column])-INT(FIND("#",[Your Calculated Column])))


http://sharepoint.stackexchange.com/questions/29140/using-calculated-field-to-retrieve-substring-of-another-field

http://stackoverflow.com/questions/10272842/sharepoint-trim-column-up-to-specific-character
0
 
MisUszatekAuthor Commented:
Thanks - it worked!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.