How can i sort data in a range or table in MS Office ?
here a sample
https://i.ibb.co/fGrqW35/CSV-Export.png
CSV Export: Format Cells in Excel ? (or MS Excel Question)
Moderators: fgagnon, nikos, Site Mods
Re: CSV Export: Format Cells in Excel ? (or MS Excel Question)
Hi,
1. Copy and paste the data in a plain text file.
2. In Excel, go to "Data" tab and select "From Text/CSV), select the text file from step 1, and follow the wizard.
Regards,
1. Copy and paste the data in a plain text file.
2. In Excel, go to "Data" tab and select "From Text/CSV), select the text file from step 1, and follow the wizard.
Regards,
Re: CSV Export: Format Cells in Excel ? (or MS Excel Question)
dont works can you create a tutroial video ?
Re: CSV Export: Format Cells in Excel ? (or MS Excel Question)
in xplorer2 use EDIT > EXPORT CSV to extract the contents, then use your excel skills
Re: CSV Export: Format Cells in Excel ? (or MS Excel Question)
How can i sort data in a range or table in MS Office ?
Re: CSV Export: Format Cells in Excel ? (or MS Excel Question)
that's not an xplorer2 question but you can use the SORT button in the DATA ribbon tab, then pick a column