How do I parse database "name" field into first and last name?

[CRM user]

I have a field that is being inserted into Word 2003 from MS-CRM 3.0 through
c360 mail merge. The native field in MS-CRM passes the "name" field to
MS-Word as lastname, firstname (concatentated). I need to display the name
as firstname lastname in the word document. Does anyone know how to do this?

 

[bigrho1]

The split function will allow to parse the name and then reorder as necessary:

astrWords = Split(name, " ") 'set delimiter
strLast = astrWords(UBound(astrWords)) 'find last name
strFirst = astrWords(LBound(astrWords)) 'find first name
NewName=strFirst & " " & strLast