It's very frustrating as I would never use anything other than a comma in a file of "Comma Separated Values"! I'd certainly never use the tab character in the creation of a table in a text file. No modification of Control Panel Regional Settings seems to work. ![]() Of course, I can remove the check and place a check by the comma, but can I make that solution permanent? CSV files) or the delimiter (in this case, I'm looking at commas since that's what the 'C' in CSV stands for), when I select File / Open (from within Excel) the Text Import Wizard always selects TAB as the delimiter. Regardless of the file extension (in this case, I'm mostly concerned about. So you cannot use Text to Columns to do a bunch of numbers followed by a period. The other one (s), have to be from the selection of Tab, Semicolon, Comma, and Space. How do I get the control indicated below to be selected by default? That way, I could just open a CSV file and hit "Finish" with no further clicking. With Text to Columns, you CAN choose multiple delimiters, but only one can be custom, and it can only be exacly one character long. Neither this nor this is the same question, nor do they give clues to the answer. Is it possible to permanently modify this default to be a comma?ĭon't be tempted to think that this is a duplicate question. Within the Text import Wizard, the default delimiter is TAB.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |