Solved

SP 2007 Calculated column

Posted on 2013-01-25
1
201 Views
Last Modified: 2013-01-31
I am using sharePoint 2007.

Is there a way in a calculated column to extract the first 3 characters of a string?
Ex.

If my column has "1.1.2.1".  Is there a way to just get "1.1"?

Thanks for any help you can give
0
Comment
Question by:Isaac
1 Comment
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
ID: 38820124
Hi,
short answer: yes:

=LEFT(Column,3)

HTH
Rainer
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…

837 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