Hi,
Merry Christmas !!!
please i need some help on =LEN function
On daily basis I Have a groups of Numbers On Cell G4 to G109
FOR EXAMPLE
On Cell H4 I input the len function as =LEN(G4)
And this function count each Digit plus the character "-"
EXAMPLE what im getting (i don't want this)
IncorrectLEN.png
What i need is to count just the Numbers, not the character "-"
Also i tryed others LEN Functions and didn't work for me
e.i
=LEN(G4)-LEN(SUBSTITUTE(G4,",",""))+1
Example what i do need (desired output)
DesireOutput.png
Thanks
David
Best Regards from Miami.
Bookmarks