Page 1 of 1
CSV Export: Format Cells in Excel ? (or MS Excel Question)
Posted: 2020 Feb 14, 13:25
by pearliner
How can i sort data in a range or table in MS Office ?
here a sample
https://i.ibb.co/fGrqW35/CSV-Export.png
Re: CSV Export: Format Cells in Excel ? (or MS Excel Question)
Posted: 2020 Feb 14, 15:25
by sanferno
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,
Re: CSV Export: Format Cells in Excel ? (or MS Excel Question)
Posted: 2020 Feb 14, 21:00
by pearliner
dont works can you create a tutroial video ?
Re: CSV Export: Format Cells in Excel ? (or MS Excel Question)
Posted: 2020 Feb 15, 11:32
by nikos
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)
Posted: 2020 Feb 16, 16:17
by pearliner
How can i sort data in a range or table in MS Office ?
Re: CSV Export: Format Cells in Excel ? (or MS Excel Question)
Posted: 2020 Feb 16, 17:26
by nikos
that's not an xplorer2 question but you can use the SORT button in the DATA ribbon tab, then pick a column