Hi guys,
Using this formula:
=(LEN(TRIM(G2))-LEN(SUBSTITUTE(G2," ",""))+1)
How do I change it to say if a cell is blank, return 0 instead of 1. It is counting blank cells as 1 suggesting it has a word but it doesn't1!
thank you
Hi guys,
Using this formula:
=(LEN(TRIM(G2))-LEN(SUBSTITUTE(G2," ",""))+1)
How do I change it to say if a cell is blank, return 0 instead of 1. It is counting blank cells as 1 suggesting it has a word but it doesn't1!
thank you
Thanks,
R.
Try this:
=LEN(TRIM(G2))-LEN(SUBSTITUTE(G2," ",""))+(G2<>"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks