THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

John Paul Cook

Adding a comma to a resource name in Microsoft Project

Microsoft Project does not allow a comma to be added to a resource name. In healthcare, the norm is to refer to people using the pattern of Name, Title which in my case is John Cook, RN. Not all commas are equal. By substituting a different comma for the one Project doesn’t like, it’s possible to add a comma to a resource name.


Figure 1. Error message after trying to add a comma to a resource name in Microsoft Project 2013.

The error message refers to “the list separator character” that is commonly known as a comma. The comma that we can’t use in Project resource names is technically known as U+002C, which is its number in the Unicode character set. There is another comma known as U+201A. They look the same, but they aren’t treated the same internally.

Microsoft Project doesn’t provide a way to directly enter Unicode characters, but the Character Map tool included with Windows gives you a way to copy a Unicode character to your copy/paste buffer. To invoke the Character Map utility, you can use the search box to find it.


Figure 2. Finding the Character Map utility.

Once the Character Map is visible, there are four quick and easy steps to follow:

1. Check the Advanced view checkbox.

2. Enter 201A in the Go to Unicode: textbox.

3. Click the Select button.

4. Click the Copy button.


Figure 3. Using the Character Map utility.

Now the special comma is stored in your copy/paste buffer ready to be pasted into the Resource Information dialog box.

Position your cursor where you want the comma to be and paste it using whatever technique you prefer. I used Ctrl-V.


Figure 4. Resource name field with a U+201A comma pasted after my name and before my title.


Figure 5. Assign Resources dialog box with commas and titles added to all resources.

When there is only one resource with a comma and a title, the workaround looks perfect. When there are multiple resources, the commas that are resource separators do not have a preceding space, which causes things to appear slightly jumbled up as shown in the screen capture below.


Figure 6. How the comma separated titles appear on the project chart.

Published Saturday, June 22, 2013 11:42 PM by John Paul Cook

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



zzyytt said:">">">">

May 1, 2018 7:01 PM

linying123 said:


May 10, 2018 8:11 PM

shenyuhang said:


June 1, 2018 7:09 PM

Leave a Comment


About John Paul Cook

John Paul Cook is a database and Azure specialist in Houston. He previously worked as a Data Platform Solution Architect in Microsoft's Houston office. Prior to joining Microsoft, he was a SQL Server MVP. He is experienced in SQL Server and Oracle database application design, development, and implementation. He has spoken at many conferences including Microsoft TechEd and the SQL PASS Summit. He has worked in oil and gas, financial, manufacturing, and healthcare industries. John is also a Registered Nurse currently studying to be a psychiatric nurse practitioner. Contributing author to SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2. Connect on LinkedIn

This Blog



Privacy Statement