• 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.

Search results

  1. T

    Importing to excel from notepad

    Thanks for the quick response. I have more of an issue though. Attached is what the sheet looks like between rows 1-40456 all with different users
  2. T

    Importing to excel from notepad

    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...
  3. T

    Delete duplicates within a single cell?

    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...
  4. T

    Delete duplicates within a single cell?

    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...
  5. T

    Trying to get emails from one worksheet table to another

    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...
Back
Top