Forum Discussion
If function
I have a column that contains a text entry of A,A-,B+,B,B-,C+,C,C-. I need a formula in another column that will return only the values of C+, C, C-. I have tried =If statements but have not had any...
Lets try isolating the first letter of your text so that we only need the letter "C" like this
=IF(LEFT(A:1,1)="C",A1,"")