Getting First and Last Name from username

I have an excel/comma delimited file that contains a list of usernames. Is there a way to use that list and get the First and Last Name of the users so that they can be imported into excel? This is on Windows 2000 Active Directory by the way.
LVL 9
gbarrientosAsked:
Who is Participating?
 
QuetzalConnect With a Mentor Commented:
Open Active Directory for Users and Computers.  Click on the Container that has the users defined.  Click on View->Choose Columns and select User Logon Name, First Name, and Last Name.  Right-click the container and choose Export List.  Choose tab delimited format.   You can use the Excel text import wizard to import this file, just be sure to choose tab as the delimiter.
0
 
stafiCommented:
open excel - file>open - change the "files of type" to text files and open the csv file
now you have to configure the "text import wizard" and when you finish you mast save the result again as an excel file.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.