Hi
I want to count how many characters there are within a cell, I'm using =LEN(D235) to count the characters, no problem but my query is.... if the cell contains no character then how do I get it to default to show 1 and not 0 ??
Thanks
Hi
I want to count how many characters there are within a cell, I'm using =LEN(D235) to count the characters, no problem but my query is.... if the cell contains no character then how do I get it to default to show 1 and not 0 ??
Thanks
![]()
Please Login or Register to view this content.
Hi,
=max(1,len(d235))
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
hello
space not include in count
=MAX(1,LEN(SUBSTITUTE(d235," ","")))
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hey Vlady,
Do you thing spaces don't or shouldn't count in a length of string? I must have missed that in my education. Please point me to a link.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
just giving the op option on whether to count space between the words...
or better issue a trim before count to delete spaces. sometimes mistakenly press spacebar before enter.
=MAX(1,LEN(TRIM(d235)))
space Hello there. space
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks