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