•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Confirm character count without the LEN function
Trying to solve this spreadsheet puzzle where you need to output TRUE in B2 if the character count in A2 is <10 and FALSE otherwise, but I'm not allowed to use the LEN function.
| A | B | |
|---|---|---|
| 1 | Text | Target |
| 2 | Hello | [Formula goes here] |
| 3 | Spreadsheets | (Copies from cell above) |
| 4 | AI | (Copies from cell above) |
Any ideas?
[link] [comments]
Want to read more?
Check out the full article on the original site