Ramballah
Active Member
- Joined
- Sep 25, 2018
- Messages
- 311
- Office Version
- 365
- Platform
- Windows
Hello everyone,
I have a few columns where cells will be formatted as followed:
Some cells have letters in them and some dont. However due to this all the cells formatting is plain text. So if i use =ISTEXT then even the cells with just numbers will come up as true.
I need to mark down the cells that contain letters but by using ISTEXT, the ones without letters will also get marked. I tried multiple ways to use custom formatting but I just couldn't find any results.
Google bare no fruits either. So hopefully someone can help me out.
I should mention this is currently in google spreadsheets but I can also convert it to Excel 360.
Thanks in advance,
Ram
I have a few columns where cells will be formatted as followed:
Some cells have letters in them and some dont. However due to this all the cells formatting is plain text. So if i use =ISTEXT then even the cells with just numbers will come up as true.
I need to mark down the cells that contain letters but by using ISTEXT, the ones without letters will also get marked. I tried multiple ways to use custom formatting but I just couldn't find any results.
Google bare no fruits either. So hopefully someone can help me out.
I should mention this is currently in google spreadsheets but I can also convert it to Excel 360.
Thanks in advance,
Ram