If I understand well, you can use the following array formula: =SUM(LEN (A1:D22)). Note: press CTRL+SHIFT+ENTER to enter the formula. the formula syntax and usage of the LEN and LENB functions in Microsoft Excel. If you need to, you can adjust the column widths to see all the data. Having trouble using the correct syntex to display in an excel spreadsheet. Would like the word WRITE to display in a cell if the length of.