May 31 2020 03:49 AM
Bonjour,
Comment séparer un nombre de 3 chiffres ex: 258 en 1 chiffre par colonne soit 2(colonne 1); 5(colonne 2); 8(colonne 3)
Merci pour votre retour
May 31 2020 04:05 AM
May 31 2020 04:20 AM - edited May 31 2020 04:22 AM
2+5+8 is not 12!!
=SUM(0+MID(A1,{1;2;3},1))
French versions of Excel:
=SOMME(0+STXT(A1;{1;2;3};1))
Regards
Jun 01 2020 01:34 AM
Many thanks for your reply! I really appreciate it.
I have another question: what formula could I use to add up each number from one cell such as 24129754
2+4+1+2+9+7+5+4 =35
Jun 01 2020 02:57 AM