by John MacDougall | Aug 17, 2017 | Formulas
Example =RIGHT(B3,LEN(B3)-FIND(“@”,B3)) Download Example File Generic Formula =RIGHT(Email,LEN(Email)-FIND(“@”,Email)) Email – This is the email address from which you’d like to extract the domain from. What It Does This formula...
by John MacDougall | Aug 16, 2017 | Formulas
Example =LEN(B3)-LEN(SUBSTITUTE(B3,C3,””)) Download Example File Generic Formula =LEN(Text)-LEN(SUBSTITUTE(Text,Character,””)) Text – This is the text string in which you want to count the occurrences of a given single character....
by John MacDougall | Aug 13, 2017 | Formulas
Example =DAY(EOMONTH(B3,0)) Download Example File Generic Formula =DAY(EOMONTH(Date,0)) Date – This is the date for which you want to return the last day of the month. What It Does This formula will return the last day of the month from the date selected. How It...
by John MacDougall | Aug 13, 2017 | Formulas
Example Download Example File Generic Formula =RIGHT(CELL(“filename”),LEN(CELL(“filename”))-FIND(“]”,CELL(“filename”))) filename – This is a system defined input for the CELL function. What It Does This formula...
by John MacDougall | Aug 13, 2017 | Formulas
Example =PROPER(LEFT(B3,FIND(“.”,B3)-1)) Download Example File Generic Formula =PROPER(LEFT(Email,FIND(“.”,Email)-1)) Email – This is the email address which we want to extract the first name from. It is assumed to be of the...