CSV Exports Single Column
Basic information on changing GeeDee CSV exports to single column with MS Excel.
When you select the "A" Paste Options choosing "Keep Text Only (T)", additional Paste Options appear at the bottom, Click and select the "Use Text Import Wizard...".
Copy and paste into original database sheet or desired location...
1.) Opens List and presses the <CTRL> and the <A> keys at the same time.
2.) Goes to menu and opens Libre Office Calc.
3.) Selects a cell, any cell, and presses <Control> and <V> at the same time.
4.) Views the "language" dialogue box, and accepts the default of Automatic.
5.) If your "any cell" was A1, select columns A to D, then select <Format> -> <Merge Cells> -> <Split Cells>.
6.) With columns A to D still highlighted, Select <Data>, <sort> then choose to sort on column C in ascending or descending order if you want price, column A if you want alphabetical order, column B if you want original price or column D if you want to get the biggest discount regardless of what crap you order.
© GeeDee for Windows Pty Ltd 1984 - 2018 All rights reserved. Real Estate Software by Real Estate Professionals.
Trust Accounting & Property Management Software with Enterprise Electronic Document Management.