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.

If len excel - most its

I searched the web for formulas for this and concluded that you either need a lot of nesting and a difficult to follow formula or a VBA function. Last edited by teylyn; at I have column B that I need to test the length to see if it is longer than characters. Remove characters from left. There are currently 1 users browsing this thread. Office Tab Kutools for Excel Kutools for Word Kutools for Outlook.

## 0 Comments