Fonction pour Compter le nombre de texte dans un cellule
Bonjour à tous,
J'ai vraiment besoin d'aide pour ce cas la
Exemple:
La valeur de A1 est :
{"url": null, "items": [{"coords": {"x": 4, "y": 5, "w": 233, "h": 545}, "selected": false, "data": {"box_type": "person", "well_framed_person": "yes", "gender": "Adult (Female)", "position": "standing", "category": "", "sub_category": "", "apparel_gender": "", "pair_label": ""}}, {"coords": {"x": 40, "y": 13, "w": 180, "h": 445}, "selected": false, "data": {"box_type": "apparel", "well_framed_apparel": "yes", "in_ethnic_wear": "no", "gender": "", "position": "", "category": "one_piece", "sub_category": "", "apparel_gender": "Adult (Female)", "pair_label": ""}}, {"coords": {"x": 43, "y": 22, "w": 185, "h": 419}, "selected": false, "data": {"box_type": "apparel", "well_framed_apparel": "yes", "in_ethnic_wear": "no", "gender": "", "position": "", "category": "tops", "sub_category": "", "apparel_gender": "Adult (Female)", "pair_label": ""}}, {"coords": {"x": 40, "y": 313, "w": 177, "h": 166}, "selected": false, "data": {"box_type": "apparel", "well_framed_apparel": "yes", "in_ethnic_wear": "yes", "gender": "", "position": "", "category": "bottom", "sub_category": "pants", "apparel_gender": "Adult (Female)", "pair_label": ""}}, {"coords": {"x": 0, "y": 471, "w": 71, "h": 63}, "selected": false, "data": {"box_type": "apparel", "well_framed_apparel": "", "in_ethnic_wear": "", "gender": "", "position": "", "category": "footwear", "sub_category": "open_footwear", "apparel_gender": "Adult (Female)", "pair_label": "A"}}, {"coords": {"x": 153, "y": 485, "w": 67, "h": 62}, "selected": false, "data": {"box_type": "apparel", "well_framed_apparel": "yes", "in_ethnic_wear": "", "gender": "", "position": "", "category": "footwear", "sub_category": "open_footwear", "apparel_gender": "Adult (Female)", "pair_label": "A"}}], "image_dim": {"w": 424, "h": 947}}
Puis, je dois avoir le nombre total de texte "data" dans cet cellule A1
Merci de votre reponse
Bonjour,
Si tu veux juste compter le nombre de mots dans la cellule A1:
Mots séparés par un espace:
=counta(split(A1;" "))
Mots séparés par un caractère(par exemple: ";"):
=counta(split(A1;";"))
Cordialement,
Fil.
Merci Filoche de votre aimable réponse.
Bonjour Hasina,
Peux-tu clôturer le sujet que tu as ouvert, stp?
Toi seule peux le faire...
Bonne journée,
Fil.