Splitting problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2298172%22%20slang%3D%22en-US%22%3ESplitting%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2298172%22%20slang%3D%22en-US%22%3E%3CP%3Eeven%20though%20i%20get%20a%26nbsp%3B%20data%20which%20are%20already%20properly%20arranged%20in%20row%20and%20column%20and%20as%20soon%20as%20i%20open%20it%20in%20my%20excel%20it%20comes%20in%20a%20single%20cell%26nbsp%3B%20but%20i%20tried%20to%20split%20the%20single%20cell%20into%20multiple%20columns%20and%20rows%20but%20the%20decimal%20position%20of%20some%20number%20are%20changing%20.%20Please%20help%20me%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2298172%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2298515%22%20slang%3D%22en-US%22%3ERe%3A%20Splitting%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2298515%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1038516%22%20target%3D%22_blank%22%3E%40keshab1610%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBetter%20to%20have%20the%20file%2C%20not%20sure%20what's%20wrong%20with%20decimal%20positions.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20split%20the%20text%20select%20column%20A%2C%20Data-%26gt%3BText%20to%20Columns%2C%20use%20comma%20as%20delimiter%20and%20follow%20wizard%20instructions.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

even though i get a  data which are already properly arranged in row and column and as soon as i open it in my excel it comes in a single cell  but i tried to split the single cell into multiple columns and rows but the decimal position of some number are changing . Please help me

1 Reply

@keshab1610 

Better to have the file, not sure what's wrong with decimal positions.

 

To split the text select column A, Data->Text to Columns, use comma as delimiter and follow wizard instructions.