richiwatts
Board Regular
- Joined
- Aug 27, 2002
- Messages
- 131
I have a column like this.
Quality Score: 5 (20180412)
Quality Score: 5 (20180220)
Quality Score: 4 (xxxxxxxx)
Quality score: 4 (20180713)
Quality Score; 4 (20180605)
I need to get just the scores in a different column so I can average them in a pivot base don toher criteria I have in other columns.
I was able to get the score in a new column using
=IFERROR(MID(F8,16,LEN(F8)-26))
But then it is not a number it is text so I can't get an average. I tried formatting the numbering but that didn't work.
Can you think of a way I can get just the number? The data is constantly updating so I can't just search and replace, I need a formula or something.
Thanks
Quality Score: 5 (20180412)
Quality Score: 5 (20180220)
Quality Score: 4 (xxxxxxxx)
Quality score: 4 (20180713)
Quality Score; 4 (20180605)
I need to get just the scores in a different column so I can average them in a pivot base don toher criteria I have in other columns.
I was able to get the score in a new column using
=IFERROR(MID(F8,16,LEN(F8)-26))
But then it is not a number it is text so I can't get an average. I tried formatting the numbering but that didn't work.
Can you think of a way I can get just the number? The data is constantly updating so I can't just search and replace, I need a formula or something.
Thanks