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...
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