On 08 Jan 2020 05:11, Gerald Boutin wrote:
By the way, I generally don't bother with that solution and just do what you do, which is to paste text into the spreadsheet.
My solution does not involve pasting into the spreadsheet (although I seem to recall someone else made such a suggestion).
My solution is to open a blank worksheet and (in Excel 2016) use Data > Get & Transform Data > Get Data > From File > From Text/CSV. In Excel 2003, it's Data > Import External Data > External Data.
Samuel
Samuel Murray