O que faltava mesmo – MS Excel

 Era mesmo isto que faltava para trabalhar as bases de dados, que cada vez mais me aparecem. Alguma pesquisa lá deu fruto.

To change the default on your PC to a pipe rather than a comma bring up your default options window by clicking Start -> Settings -> Control Panel -> Regional Settings.

Click the “Number” tab and in the “List Separator” field, replace the current default separator with the one you want to use (let’s say a pipe symbol | ).

Click “OK” to save the change and close the window. You can now save Excel files as pipe delimited files by simply doing the following in Excel:

Leave a Comment

Your email address will not be published. Required fields are marked *