• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pull initials from name with student number

Jack-P-Winner

Jack-P-Winner

Member
I am trying to help a friend on a spreadsheet.

The Students email will consist of their first initial with their last name @xxxxxxcharter.org. Their password will have to be at least 8 digits long. The numbers in D need to be their password. If Possible I would prefer their password to have their first name initial and last name initial added in front. such as John Doe 123456789, the password would be jd123456789. He has approx. 500 students....

so in recap, he has a list with their first and last names in A and B output needed is in C with their 1st initial and last name @ their email address. The student ID is in D and needed output in E would add their first and last initial to their student ID number in D. How can this be done?

I am not sure if this is code or a MACRO and as ALWAYS I appreciate your help!!!!
 

Attachments

  • Charter.org.xlsx
    10.7 KB · Views: 13
when I do this it only pulls the info from D. Hmm, presently lets say I do not have their email address in C all I have is the first and last name and student ID. So, I know AB ad D. I need to put in C their email address which will be first initial from their first name with their last name @xxxxxcharter.net and then in E the initials plus student id that is in D

Make sense
 
thank you for the explanation...
So formula in C2 should be =LEFT(A2,1)&B2&"@xxxxxcharter.net"
and E2 should be =LEFT(A2,1)&LEFT(B2,1)&D2

Does this help...!!
 
If some student ids are less than 8 digits, then I would amend Asheesh's formula in E2 to be:
=LEFT(A2,1)&LEFT(B2,1)&TEXT(D2,"00000000")
or something like that, to force a minimum length.
 
As always, works like a charm! THANK YOU!!!!

Have one exception, he now tells me he has two with the same first initial LOL, how can I place the first name AND last name instead of 1st initial and last name>

Thanks
 
You must log in or register to reply here.
Back
Top