•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
Tagged with
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#big data management in spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#AI-native spreadsheets
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#predictive analytics in spreadsheets
#AI-powered spreadsheet
#cloud-native spreadsheets