Excel Formula for Asset Import
Does anybody have an Excel formula for the following please ?
I have tested the import assets function in SDP. Works well except that usernames in our current system are stored as Joe Bloggs. In SDP they are stored as Bloggs, Joe. If I leave SDP to odrt this then it created new users.
So I need an Excel formula that changes Joe Bloggs into Bloggs, Joe.
Many thanks in advance.
I have tested the import assets function in SDP. Works well except that usernames in our current system are stored as Joe Bloggs. In SDP they are stored as Bloggs, Joe. If I leave SDP to odrt this then it created new users.
So I need an Excel formula that changes Joe Bloggs into Bloggs, Joe.
Many thanks in advance.