Pod uslovom da je "uzastopni niz" u jednoj ćeliji i da se potrudiš da ti nigde ne bude više od jednog razmaka (npr sa ReplaceAll izmeniš sve duple razmake samo sa jednim), onda bi ovo trebalo da posluži:
Code:
=LEN(MAX(FILTERXML("<t><s>" & SUBSTITUTE(A1;"_";"</s><s>") & "</s></t>";"//s")))
Formulu treba uneti sa Ctrl+Shift+Enter.
Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!