Splitting problem

Copper Contributor

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.