Hi Friends,

I'm using a Len Function to count some digits with in string.

For Example, in G12 Down I have :

_____G:12_____________
12 l 10-16-17-22-23 l
13 l 03-11-14-24-26 l
14 l 17-19-25-28-35 l


So in next Cell i'm using LEN Function to do the count,
=LEN(G12)+1/3
Note : i changed/combined the digits after the plus sign, Also i add TRIM but it didn't work
it get changed for other s fraction..


When LEN find
1 Digit, it write 1 <- Perfect
2 Digit, it write 2 <- Perfect
3 Digit, it write 3 <- Perfect
BUT
When LEN find 0 Digit, it write 0.333333 <- IMPERFECT Lol

i would like to replace the 0.333333 to 0 (Just the Digit zeroe)

How can i do that ?, any help please?


Best regards

David