Example =LEN(B3)-LEN(SUBSTITUTE(B3,C3,"")) Generic Formula =LEN(Text)-LEN(SUBSTITUTE(Text,Character,"")) Text - This...
How To Count A Specific Character In A Cell (Case Sensitive)
read more
About the Author
John MacDougall
John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.
Subscribe
Subscribe for awesome Microsoft Excel videos 😃
Articles from John MacDougall
How to Get the Last Day of the Month
Example =DAY(EOMONTH(B3,0)) Generic Formula =DAY(EOMONTH(Date,0)) Date - This is the date for which you want to return...
How to Get the Current Sheet Name
Example Generic Formula =RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("]",CELL("filename"))) filename...
Get the Latest Microsoft Excel Tips
Follow Us
Follow us to stay up to date with the latest in Microsoft Excel!
Subscribe for awesome Microsoft Excel videos 😃