Excel Formulas: I use Excel almost everyday to produce numbers for the higher ups and the innovation of Excel programmers never ceases to amaze me. Here is a formula to count the total number of times a certain character shows up in a string. High level programming has me so caught up in functions that this simple trick evaded me completely. Count = LEN(B1)-LEN(SUBSTITUTE(SUBSTITUTE(B1,”B”,””),”b”,””))
[Continue Reading...]