Séparer un nombre de 3 chiffres en 1 chiffre par colonne

%3CLINGO-SUB%20id%3D%22lingo-sub-1429595%22%20slang%3D%22fr-FR%22%3ESeparate%20a%203-digit%20number%20into%201%20digit%20per%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1429595%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20separate%20a%20number%20of%203%20digits%20ex%3A%20258%20in%201%20digit%20per%20column%20or%202%20(column%201)%3B%205%20(Column%202)%3B%208%20(Column%203)%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20return%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1429595%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1429611%22%20slang%3D%22fr-FR%22%3ERe%3A%20Separate%20a%203%20digit%20number%20into%201%20digit%20per%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1429611%22%20slang%3D%22fr-FR%22%3EI'll%20take%20my%20question%20back.%20I%20have%20to%20add%20each%20number%20separately%202%20-%205%20-%208%20-%2012%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1429627%22%20slang%3D%22en-US%22%3ERe%3A%20S%C3%A9parer%20un%20nombre%20de%203%20chiffres%20en%201%20chiffre%20par%20colonne%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1429627%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F684704%22%20target%3D%22_blank%22%3E%40FRANCEBU%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2%2B5%2B8%20is%20not%2012!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000080%22%3E%3CSTRONG%3E%3DSUM(0%2BMID(A1%2C%7B1%3B2%3B3%7D%2C1))%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3EFrench%20versions%20of%20Excel%3A%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000080%22%3E%3CSTRONG%3E%3DSOMME(0%2BSTXT(A1%3B%7B1%3B2%3B3%7D%3B1))%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1430513%22%20slang%3D%22fr-FR%22%3ERe%3A%20Separate%20a%203%20digit%20number%20into%201%20digit%20per%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1430513%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676180%22%20target%3D%22_blank%22%3E%40Jos_Woolley%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20for%20your%20reply!%20I%20really%20appreciate%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20another%20question%3A%20what%20formula%20could%20I%20use%20to%20add%20up%20each%20number%20from%20one%20cell%20such%20as%2024129754%26nbsp%3B%3C%2FP%3E%3CP%3E2%2F4-1-2-9-7-5-4%20-35%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1430616%22%20slang%3D%22en-US%22%3ERe%3A%20S%C3%A9parer%20un%20nombre%20de%203%20chiffres%20en%201%20chiffre%20par%20colonne%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1430616%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F684704%22%20target%3D%22_blank%22%3E%40FRANCEBU%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20general%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000080%22%3E%3CSTRONG%3E%3DSUMPRODUCT(0%2BMID(A1%2CROW(INDEX(A%3AA%2C1)%3AINDEX(A%3AA%2CLEN(A1)))%2C1))%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

4 Replies
Highlighted
Je reprends ma question. Je dois additionner chaque chiffre séparément 2 + 5 + 8 = 12
Highlighted

@FRANCEBU 

 

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

Highlighted

@Jos_Woolley 

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

Highlighted

@FRANCEBU 

 

In general:

 

=SUMPRODUCT(0+MID(A1,ROW(INDEX(A:A,1):INDEX(A:A,LEN(A1))),1))

 

Regards