Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1815143%22%20slang%3D%22en-US%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1815143%22%20slang%3D%22en-US%22%3EI%20have%20a%20formula%20written%20to%20pull%20the%20first%202%20left%20digits%20from%20each%20cell%20(f2%3Aj2).%20The%20values%20are%20put%20in%20cells%20(a2%3Ae2).%20I%20am%20trying%20to%20get%20the%20values%20from%20cells%20(a2%3Ae2)%20combined%20into%20cell%20(a5).%20These%20numbers%20need%20to%20be%20listed%20in%20ascending%20order%20separated%20by%20a%20comma.%20I%20am%20getting%20%23NUM!%20Error%20when%20I%20hit%20the%20enter%20key.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1815143%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1815162%22%20slang%3D%22de-DE%22%3ESubject%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1815162%22%20slang%3D%22de-DE%22%3EWith%20your%20permission%2C%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%20Even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%3CBR%20%2F%3EIt%20would%20be%20a%20great%20help%2C%20you%20don't%20have%20to%20readjust%20everything%20yourself%20to%20see%20where%20the%20problem%20could%20be.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20understanding%20and%20patience%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1815298%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1815298%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F844593%22%20target%3D%22_blank%22%3E%40Sparky_Athena%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20use%20SMALL()%20you%20need%20first%20to%20convert%20texts%20in%20A2%3AE2%20into%20the%20numbers%2C%20it%20could%20be%20done%20by%20double%20dash%20in%20front%20of%20the%20range%20reference.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20696px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229060i02B44885CD843436%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor
I have a formula written to pull the first 2 left digits from each cell (f2:j2). The values are put in cells (a2:e2). I am trying to get the values from cells (a2:e2) combined into cell (a5). These numbers need to be listed in ascending order separated by a comma. I am getting #NUM! Error when I hit the enter key.
2 Replies
Highlighted
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.
It would be a great help, you don't have to readjust everything yourself to see where the problem could be.

Thank you for your understanding and patience

Nikolino
I know I don't know anything (Socrates)
Highlighted

@Sparky_Athena 

To use SMALL() you need first to convert texts in A2:E2 into the numbers, it could be done by double dash in front of the range reference.

image.png