Solved

Sharepoint calculated column with trim?

Posted on 2010-08-16
1
1,037 Views
Last Modified: 2012-05-10
I need to create a new Sharepoint calculated column that will combine Column A and Column B and trim the output to an XX amount of characters. How can I do it? Thanks
0
Comment
Question by:MisUszatek
1 Comment
 
LVL 16

Accepted Solution

by:
raybies earned 250 total points
ID: 33450832
Easy.

1.- Create calculated field
2.- Formula=LEFT(ColumnA,3)&LEFT(ColumnB,3)


Change 3 to the number of chars you want.
U can also use functions like FIND, RIGHT, TRIM, LEN... depending what you want to do.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
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…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

911 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

20 Experts available now in Live!

Get 1:1 Help Now