Excel Strip out a string

In Excel, when trying to remove a string of charactes, I regularly use the fomula below. When manipulating data from AD, this proves to be very useful, so in the example below, all data is removed before a semi colon within a string:

RIGHT(F433,LEN(F433) - FIND(";",F433))

Excel Strip the first characters from a cell

I always forget this:

=RIGHT(A1,LEN(A1)-2)

In the above example 2 is the number of cells to strip off.

Output AD Information

Server 2003 and 2008 have a tool called CSVDE - this allows for importing and exporting of AD information to and from csv files.

To output files, the syntax below can be used:

csvde -d "OU=spain,OU=Users,OU=MYOffice,DC=My,DC=local" -f x:\output\spain.csv -r objectClass=user