shifting data to new column

[kochark]

Hello!

Could someone help me shift the data to the individual columns..currently all are in one column..n i need the data in separate columns.

please find attached the file.

much appreciated

kunal

[ELeGault]

This is a comma separated file... Just go to your data tab, highlight the column and Click on text to columns. From here choose Delimited, and check off comma, Next, Finish

Everything will be in its own column

[Pete_UK]

Highlight column A, click on Data | Text to Columns, then in the dialogue box click on Delimited on the first panel, then Next, then click against Comma, then Next, then click Finish.

Hope this helps.

Pete

[kochark]

Done! thanks a lot..

[sktneer]

Use Text to Columns inbuilt feature. To do so follow these steps.....

Select the col. A (by clicking on the column letter A) --> Data --> Text to Columns --> Delimited --> Next --> Check the box before Comma --> Next --> Click on the column 1 in Data Preview to highlight it with black color --> Select the radio button Date --> Finish.

Does this help?

[kochark]

thank you pete n elegault..its resolved

[kochark]

thank you sktneer

[ELeGault]

I love the multiple times this has been stated -

Kochark, Please mark this thread as solved