CSV Export: Format Cells in Excel ? (or MS Excel Question)

Discussion & Support for xplorer² professional

Moderators: fgagnon, nikos, Site Mods

Post Reply
User avatar
pearliner
Member
Member
Posts: 48
Joined: 2016 Nov 24, 22:07

CSV Export: Format Cells in Excel ? (or MS Excel Question)

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

Image

sanferno
Silver Member
Silver Member
Posts: 269
Joined: 2013 Nov 30, 18:40

Re: CSV Export: Format Cells in Excel ? (or MS Excel Question)

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,

User avatar
pearliner
Member
Member
Posts: 48
Joined: 2016 Nov 24, 22:07

Re: CSV Export: Format Cells in Excel ? (or MS Excel Question)

Post by pearliner » 2020 Feb 14, 21:00

dont works can you create a tutroial video ?

User avatar
nikos
Site Admin
Site Admin
Posts: 14532
Joined: 2002 Feb 07, 15:57
Location: UK
Contact:

Re: CSV Export: Format Cells in Excel ? (or MS Excel Question)

Post by nikos » 2020 Feb 15, 11:32

in xplorer2 use EDIT > EXPORT CSV to extract the contents, then use your excel skills :)

User avatar
pearliner
Member
Member
Posts: 48
Joined: 2016 Nov 24, 22:07

Re: CSV Export: Format Cells in Excel ? (or MS Excel Question)

Post by pearliner » 2020 Feb 16, 16:17

How can i sort data in a range or table in MS Office ?

User avatar
nikos
Site Admin
Site Admin
Posts: 14532
Joined: 2002 Feb 07, 15:57
Location: UK
Contact:

Re: CSV Export: Format Cells in Excel ? (or MS Excel Question)

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

Post Reply