Home

Répartir les chiffres d'un nombre sur plusieurs colonnes

%3CLINGO-SUB%20id%3D%22lingo-sub-1117007%22%20slang%3D%22fr-FR%22%3ESpread%20numbers%20from%20one%20number%20to%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1117007%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EHow%20do%3CFONT%3EI%20start%20a%20number%20on%20multiple%20columns%3F%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3Ein%20AL10%20I%20have%20the%20result%20of%20a%20calculation%3A%20'AL7'AL8%20whose%20size%20varies.%20Numbers%20from%203%20to%2010%20digits.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EI%20would%20like%20to%20recover%20the%20result%20of%20AL10%20by%20spreading%20each%20of%20the%20numbers%20over%20a%20range%20of%20cells.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EIf%20in%20AL10%20I%20have%20456%20as%20a%20result.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3E6%20would%20be%20in%20L10%2C%205%20in%20L9%2C%204%20in%20L8.%20Like%20what%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EThank%20you%20for%20your%20help%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1117007%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1117024%22%20slang%3D%22en-US%22%3ERe%3A%20R%C3%A9partir%20les%20chiffres%20d'un%20nombre%20sur%20plusieurs%20colonnes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1117024%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F524364%22%20target%3D%22_blank%22%3E%40scalpa%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20file%20should%20contain%20what%20you%20are%20looking%20for%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1117074%22%20slang%3D%22en-US%22%3ERe%3A%20R%C3%A9partir%20les%20chiffres%20d'un%20nombre%20sur%20plusieurs%20colonnes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1117074%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F524364%22%20target%3D%22_blank%22%3E%40scalpa%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20an%20alternative%2C%20using%20the%20fairly%20new%20SEQUENCE%20function.%20Two%20examples%20of%20how%20to%20split%20a%20cells'%20content%20vertically%20or%20horizontally.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
scalpa
Occasional Visitor

Bonjour

Comment répartir les chiffres d'un nombre sur plusieurs colonnes?

en AL10 j'ai le résultat d'un calcul : =AL7*AL8 dont la taille varie. Des nombres de 3 à 10 chiffres.

Je souhaiterais récupérer le résultat de AL10 en répartissant chacun des chiffres sur une plage de cellules.

Si en AL10 j'ai 456 comme résultat.

le 6 se trouverait en L10, le 5 en L9, le 4 en L8. par exemple

merci de votre aide

 

2 Replies
Highlighted

Hi @scalpa 

 

Attached file should contain what you are looking for

Highlighted

@scalpa 

As an alternative, using the fairly new SEQUENCE function. Two examples of how to split a cells' content vertically or horizontally.