ExcelBanter - Pulling "Title" Attribute from Active Directory

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pulling "Title" Attribute from Active Directory (https://www.excelbanter.com/excel-worksheet-functions/446449-pulling-title-attribute-active-directory.html)

itsmevic

Pulling "Title" Attribute from Active Directory

1 Attachment(s)

Hey guys,

I've got a spreadsheet and need to pull the "title attribute. In column A I have the domain name\sAMAccountName in that format and would like Column B to pull the title of that person. Any help with this is greatly appreciated.

I've attached a sample spreadsheet that shows the exact format.

Thanks again!

All times are GMT +1. The time now is 10:27 PM.