Splitting problem

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


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.