•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do ignore inconsistent text in a column and just sum the numbers?
I have a stats sheet I use for football and the formula I have been using to ignore any text in the cells and just count the numbers isn’t working anymore. I was using eg. =SUM(—TEXTSPLIT(Z3:Z48,”,”)). There are different, inconsistent strings of text in each cell that mean I cannot just sub out the same text for each cell. I want to sum all the ‘minutes’ and ignore text like the Comma, “A”, “G”, “Y”, “R”. An example of a cell would be ‘90, A, Y’ and I would like to add the 90 and ignore the text.
[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
#rows.com
#AI formula generation techniques
#Excel compatibility
#football
#minutes
#stats sheet
#formula
#SUM
#TEXTSPLIT
#inconsistent text
#ignore
#cell
#count
#inconsistent strings
#example
#string
#comma