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 luck. Any help would be greatly appreciated.
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,"")
Hi Deleted
Can I get some clarity please:
1. Are those text values sitting in a single cell in that column?
2. And if yes, do you then want to extract the C's which would be output in another single cell as C+,C,C-?
3. In other cells will you have variations of this text and will need those C's extracted too?
Just trying to get my head around your requirements.
Thanks
Damien
