Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 394
  • Last Modified:

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?
0
MisUszatek
Asked:
MisUszatek
  • 2
1 Solution
 
Rainer JeschorCommented:
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

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now