Modify_inc
Board Regular
- Joined
- Feb 26, 2009
- Messages
- 77
- Office Version
- 2016
- Platform
- Windows
Ok, I love using the IF Statement, it's very powerful and versatile, but I have a question as I'm still learning how to use it in Excel.
I have a column of data (E4:E29) that goes like this:
8=D
3=A
1=W
0=V
0=Q
etc.. for all letters in the alphabet, so 26 times, and it's always randomly generated, so 8=D could change to 0=D the next time around.
All I want to do is hide or NOT display any data that starts with a 0. So 0=V and 0=Q in this instance, needs not be displayed.
Since theses cells are formatted using Text, how can I use an If Statement to determine if the first letter = 0?
I have a column of data (E4:E29) that goes like this:
8=D
3=A
1=W
0=V
0=Q
etc.. for all letters in the alphabet, so 26 times, and it's always randomly generated, so 8=D could change to 0=D the next time around.
All I want to do is hide or NOT display any data that starts with a 0. So 0=V and 0=Q in this instance, needs not be displayed.
Since theses cells are formatted using Text, how can I use an If Statement to determine if the first letter = 0?