Excel formulas


Some handy dandy Excel formulas I use to easy my office tasks

If contains text do this
NOT reverses the ISERR logic so the execution of the IF statment is consistant
=IF(NOT(ISERR(SEARCH("FOR TEXT";A2)));DO THIS;ELSE DO THIS)

Escape qoutes by using double quotes
Search for a quote in text using 4 quotes.
=SEARCH("""";A2)

Terminate string at character

=LEFT(A2;FIND("CHARACTER";A2))
Check if string is valid file name

=OR(
IF(ISERR(SEARCH("<";K2));TRUE;FALSE); 
IF(ISERR(SEARCH(">";K2));TRUE;FALSE);
IF(ISERR(SEARCH(":";K2));TRUE;FALSE);
IF(ISERR(SEARCH("""";K2));TRUE;FALSE);
IF(ISERR(SEARCH("/";K2));TRUE;FALSE);
IF(ISERR(SEARCH("\";K2));TRUE;FALSE);
IF(ISERR(SEARCH("|";K2));TRUE;FALSE);
IF(ISERR(SEARCH("?";K2));TRUE;FALSE);
IF(ISERR(SEARCH("*";K2));TRUE;FALSE))
Trim leading white space

=TRIM(A2)

To be continued..........................