SharePoint 2010 calculated colum formula

In one of my columns I have values starting with 1;#SomeText. How can I remove those 3 first characters (1;#) using a calculated column formula?
MisUszatekAsked:
Who is Participating?
 
Rainer JeschorConnect With a Mentor Commented:
Hi,
i am currently mobile so no verification but should be
=right(column,len(column)-3)
0
 
MisUszatekAuthor Commented:
Works!
0
 
Rainer JeschorCommented:
Hi,
thanks for the points.
Now I am at my dev system and this is the more error prone solution, which will also work if your ids getting greater than one digit:
=RIGHT(Column,(LEN(Column)-IF(ISNUMBER(FIND("#",Column)),FIND("#",Column),0)))

Open in new window


HTH
Rainer
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.