•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Find a number in a string of characters
Hello,
I need a bit of guidance and help. I have a supplier statement where an item number is for eg. 12345 and it shows there was 2 items purchased. Our system logs item as Q12345XVTE and gives quantity as well. What I need is a formula to put on supplier statement that will find 12345 within our records and return our logged number of items to see if it matches supplier statement. Thank you.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#supplier statement
#item number
#quantity
#formula
#records
#match
#purchased
#logged number
#find
#items
#system logs
#guidance
#character string
#Q12345XVTE