Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 31st 21, 04:16 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2021
Posts: 1
Default Import text into colums without using the wizard

My wife was using Excel 2010 for importing bank statements in csv format to Excel. Somehow she had to tell the Wizard only once, that the text is delimited by a comma, the date format is DMY and some other things. From then on, just by double-clicking the latest bank statement, Excel would open and the text is all nicely put into columns.
With Excel 2016 this does no longer work, it seems. All the text of a row is put into one cell, with commas between the words.

Does anyone know how we can change this behaviour of Excel 2016.
We want to double-click the latest bank statement (in csv format) and expect Excel to open the file, showing the text in separate columns without first having to go through the Wizard every time.

Thanks for your help!

Norbert

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Start Excel in Text Import Wizard for data import rlelvis Setting up and Configuration of Excel 0 July 10th 08 08:40 PM
Text Import Wizard Prema Excel Discussion (Misc queries) 3 April 5th 06 03:11 PM
Text Import wizard Old Bob Excel Discussion (Misc queries) 2 December 21st 05 05:00 PM
Text Import Wizard from vba Ömer Ayzan Excel Programming 2 April 8th 05 08:29 AM
Text Import Wizard Al Mackay Excel Programming 1 February 10th 04 10:48 PM


All times are GMT +1. The time now is 12:21 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017