SharePoint 2010 calculated colum formula

Posted on 2013-12-20
Last Modified: 2013-12-20
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?
Question by:MisUszatek
  • 2
LVL 44

Accepted Solution

Rainer Jeschor earned 500 total points
Comment Utility
i am currently mobile so no verification but should be

Author Comment

Comment Utility
LVL 44

Expert Comment

by:Rainer Jeschor
Comment Utility
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:

Open in new window


Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Sharepoint Max date with criteria 2 22
sharepoint online 3 35
Convert a Master Page to HTML 16 59
Sharepoint List View 6 24
Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
This video discusses moving either the default database or any database to a new volume.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now