Hey guys,
So I used powershell to export information from AD to notepad, and im trying to import it into excel with the correct formatting. Here is how it looks in notepad:
DistinguishedName : CN=Administrator,OU=MISC,OU=_TERMED USERS,DC=xxxxx,DC=xxxx
Enabled : False
GivenName...
Thank you! What about if i wanted to do it with the email column?
currently it looks like: jon.daniels@company.com;jdaniels@company.com
I want it to look like: jon.daniels@company.com
Since all names have a different amount of characters, I can not specify how many characters i want to keep...
Hey guys. So Ive been working on getting information for everyone in my company for a while now, and im finally in the final steps. After combining all of the worksheets, and then combining rows (same name rows combined, semicolon seperates data from duplicate row), I have duplicate information...
Hey guys. I have two worksheets side by side; one has a column with emails in it, and the other has a column with no emails in it. The names in column A are somewhere in the the other worksheet that has the emails filled out.
So here is what im using to find it, and im getting N/A as the...