Discussion & Support for xplorer² professional
Moderators: fgagnon , nikos , Site Mods
pearliner
Member
Posts: 54 Joined: 2016 Nov 24, 22:07
Post
by pearliner » 2020 Feb 14, 13:25
How can i sort data in a range or table in MS Office ?
here a sample
https://i.ibb.co/fGrqW35/CSV-Export.png
sanferno
Silver Member
Posts: 295 Joined: 2013 Nov 30, 18:40
Post
by sanferno » 2020 Feb 14, 15:25
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,
pearliner
Member
Posts: 54 Joined: 2016 Nov 24, 22:07
Post
by pearliner » 2020 Feb 14, 21:00
dont works can you create a tutroial video ?
nikos
Site Admin
Posts: 16344 Joined: 2002 Feb 07, 15:57
Location: UK
Post
by nikos » 2020 Feb 15, 11:32
in xplorer2 use EDIT > EXPORT CSV to extract the contents, then use your excel skills
pearliner
Member
Posts: 54 Joined: 2016 Nov 24, 22:07
Post
by pearliner » 2020 Feb 16, 16:17
How can i sort data in a range or table in MS Office ?
nikos
Site Admin
Posts: 16344 Joined: 2002 Feb 07, 15:57
Location: UK
Post
by nikos » 2020 Feb 16, 17:26
that's not an xplorer2 question but you can use the SORT button in the DATA ribbon tab, then pick a column