•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