The Microsoft Dynamics CRM Blog
News and views from the Microsoft Dynamics CRM Team

Parsing Full Name Into Separate Name Fields

Parsing Full Name Into Separate Name Fields

  • Comments 1

Assume you are going to import Contacts into Microsoft Dynamics CRM using the Import Wizard.  The file you are going to import has the Contact full name in 1 column.  When attempting to import the Contacts using the Import Wizard you will receive an message that the Full Name column has been ignored as it is not valid for create/update.

image  image

The Full Name field in CRM is populated programmatically by concatenating the First and Last Name fields.  So in order to successfully import Contacts using the Import Wizard you must parse the Full Name column into separate First and Last Name columns.  You can do this manually which will not be very much fun assuming you have a large data set.  So I started digging into the functions within Excel to do this programmatically.  This is no specific function to do this so I performed a Bing search and found the following link.  The series of Excel functions detailed in the previous link parse the Full Name into separate First, Middle and Last Names.
Parse name functions

I have taken these functions and added them to the following Excel file to serve as an example.  This should help you quickly prepare your data for import.

Cheers,

Eric Boocock

After posting this, Jim Steger from Sonoma Partners pointed out that similarly, you could use the Text to Columns feature in Excel.

“Another way to accomplish without code/macro, is to use the Text to Columns feature in Excel to split the name cells, typically splitting on a Space. This will mess up some names that are 3 names long, but those are generally a smaller subset of your data and can be managed as well.”

Text to Columns Convert Text to Columns

Here’s a video demo of Text to Columns:

http://office.microsoft.com/home/video.aspx?assetid=ES102539721033&width=884&height=540&startindex=0&CTT=11&Origin=HA102474891033&app=EXCEL&ver=12

Thanks Jim!



  • Other option is to use "text to columns" within excel (within data tab).

    Few clicks and there is no need for programing.

Page 1 of 1 (1 items)
Leave a Comment
  • Please add 1 and 1 and type the answer here:
  • Post