Forum Discussion

keshab1610's avatar
keshab1610
Copper Contributor
Apr 27, 2021

Splitting problem

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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    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.