Seperating first and surname in Excel
Good morning all.
I hope someone can help me. Over the summer holidays I need to add a first name and a surname of many students into our active directory. Rather than go though each student and manually type the names I thought I would create a excel document and use the DSMOD USER command although I have bumped into a slight problem. Does anyone know how to separate the username into a first and surname? For example:
I need the above to change to James Smith
I have used the formula =LEFT(A17,FIND(”.“,A17)-1) but no joy.
Thanks in advance.