The LEN function is used to count characters in Excel. But it doesn’t support ranges or arrays to easily count total number of characters in a range. This article shows 2 ways to count characters in Excel in a range which uses SUMPRODUCT and SUM along with LEN.
Read the full article here: https://www.spreadsheetweb.com/count-characters-excel/

Please take the opportunity to connect and share this video with your friends and family if you find it useful.