Solved

SharePoint 2010 calculated colum formula

Posted on 2013-12-20
3
341 Views
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?
0
Comment
Question by:MisUszatek
  • 2
3 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
Comment Utility
Hi,
i am currently mobile so no verification but should be
=right(column,len(column)-3)
0
 

Author Comment

by:MisUszatek
Comment Utility
Works!
0
 
LVL 44

Expert Comment

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

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