Importing text files in Excel with the “Get & Transform” tools requires many steps. Finalize the import by clicking on “Finish”. …for defining decimals and thousands separators.For dates, you could define the order of days, months and years. For each column, you can choose the data format.Usually text fields use quotation marks marking the beginning and end of a text field.This is the character dividing the data into columns, for example “Tab”, “Semicolon” or “Comma”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |