SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In my document set (Sharepoint 2010) I have a column with type of “person or group” which I can add the name of some users to it.

The format of the names is like this: firsName1 Surname1; firstNmae2 Surname2;

However I need to change the name format in this way: Surname1, firstName and Surname2, firstNmae2

Is it possible to use calculated column to convert this column to this format? Or maybe by the use of workflows!

what are the possible solutions?

share|improve this question

You can definitely use a workflow to do it. You load the values into a workflow variable, do your string manipulations and then store then back in a text field (not a people picker field).

You can not use the Calculated field with People column.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.