question regarding Concatenate

please forgive the inexperience. im am in the process of making some changes to an excel sheet for adding multiple users to active directory. there are 4 pages in the workbook.


=CONCATENATE(MassUserCreationScriptSource!A2,MassUserCreationScriptSource!B2,MassUserCreationScriptSource!C2,MassUserCreationScriptSource!D2,MassUserCreationScriptSource!E2,MassUserCreationScriptSource!F2,MassUserCreationScriptSource!G2,MassUserCreationScriptSource!H2," ","-fn"," ",AddUsersInfoHere!B2," ","-ln"," ",AddUsersInfoHere!C2," ","-pwd"," ","P@ssw0rd"," ","-mustchpwd"," ","yes")


the following is the outcome that i get from the above command, the -fn fills in the proper name taking its info from the A2 cell, as does the --ln taking its info from the C2 cell. i tried to make the -pwd portion of the command look like the -fn and -ln but its not working for me.

dsadd user "cn=12345,ou=teststu,ou=Students,ou=DistrictUsers,ou=District,dc=sburg, dc=org" -fn tommy -ln smith -pwd P@ssw0rd -mustchpwd yes


the info that is in the A2 cell is what i would like to have take the place of "P@ssw0rd" and im having a difficult time due to my lack of experience/knowledge of excel. any and all assistance is appreciated.

i figured it out, the following is what i had to change... i may have missed a comma or something along the lines.

=CONCATENATE(MassUserCreationScriptSource!A2,MassUserCreationScriptSource!B2,MassUserCreationScriptSource!C2,MassUserCreationScriptSource!D2,MassUserCreationScriptSource!E2,MassUserCreationScriptSource!F2,MassUserCreationScriptSource!G2,MassUserCreationScriptSource!H2," ","-fn"," ",AddUsersInfoHere!B2," ","-ln"," ",AddUsersInfoHere!C2," ","-pwd"," ",AddUsersInfoHere!A2," ","-mustchpwd"," ","yes")