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.