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))
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment