Excel Functions

=DATE()

=PROPER()

=CONCATENATE()

=IF()

AND()

OR()

LEFT/RIGHT()

=MATCH/INDEX

=IFERROR()

=TRIM()

=REPLACE()

=SEARCH()

=ROUND()

=TRANSPOSE()

Previous: Caveats of popular data and file formats. Next: Regular Expressions.