•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
MID function only working for letters not numbers
Trying to do a very straightforward check of an alphanumerical code being returned correctly in a dataset by using the MID function for each variable in the code, and for some reason it’s only returning “true” / “finding” the digits with MID where the subject digit is a letter. Numbers result in a “false” / not found when doing =IF(MID formula)=character reference,True,False)
For example, searching for 2 in the first character of “2NOPE7” will result in a failed/not found, whereas searching for N in the second character will result in a success/found.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#no-code spreadsheet solutions
#rows.com
#AI formula generation techniques
#Excel compatibility
#large dataset processing
#financial modeling with spreadsheets
#formula generator
#Excel alternatives
#MID function
#Excel
#Alphanumerical code
#Dataset
#Character reference
#Digits
#Letters
#Formula
#IF statement