Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.