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: 54
Joined: 2016 Nov 24, 22:07

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

Post 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

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

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

Post 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,
User avatar
pearliner
Member
Member
Posts: 54
Joined: 2016 Nov 24, 22:07

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

Post by pearliner »

dont works can you create a tutroial video ?
User avatar
nikos
Site Admin
Site Admin
Posts: 15771
Joined: 2002 Feb 07, 15:57
Location: UK
Contact:

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

Post by nikos »

in xplorer2 use EDIT > EXPORT CSV to extract the contents, then use your excel skills :)
User avatar
pearliner
Member
Member
Posts: 54
Joined: 2016 Nov 24, 22:07

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

Post by pearliner »

How can i sort data in a range or table in MS Office ?
User avatar
nikos
Site Admin
Site Admin
Posts: 15771
Joined: 2002 Feb 07, 15:57
Location: UK
Contact:

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

Post by nikos »

that's not an xplorer2 question but you can use the SORT button in the DATA ribbon tab, then pick a column
Post Reply