Hi all!
I need a formula that will help me to change the order of first name and last name. The hard part is that the report from the system has the name listed as First Name Last Name - Employee Number. The number of characters is different with each employee and the only delimiter that I have is the hyphen, which is also in some people's names. I need it to be Last Name, First Name to work with the other reports I'm using. Any ideas? All help is greatly appreciated!!
I need a formula that will help me to change the order of first name and last name. The hard part is that the report from the system has the name listed as First Name Last Name - Employee Number. The number of characters is different with each employee and the only delimiter that I have is the hyphen, which is also in some people's names. I need it to be Last Name, First Name to work with the other reports I'm using. Any ideas? All help is greatly appreciated!!