![]() ![]() but it's only now that I've realised that it's. Since then, I've installed programs/steam games etc. Pretty plain and simple, put it into the computer and booted up the PC. ![]() Hi All,So the other day, I bought a 4TB hard drive (cause my SSD is only 1TB lol). In the "File Type" drop down, select "CSV (comma separated values) *.csv". Pipe delimited files by simply doing the following in Excel: Separator with the one you want to use (let's say a pipe symbol | ).Ĭlick "OK" to save the change and close the window. Options window by clicking Start -> Settings -> Control Panel -> Regional Settings.Ĭlick the "Number" tab and in the "List Separator" field, replace the current default To change the default on your PC to a pipe rather than a comma bring up your default The use of a macro is required to be able to export an excel sheet to a file with aīut we can try out this simple trick hope it works for you : ![]() Well you 'll have to write it yourselves guys : MS dudes have not thought about theįact that some values in cells could have commas or tabs. (Embedded image moved to file: pic45478.jpg) Subject: RE: replace comma delimiter with a pipe in text document Question as my email seems to stripping out rest of the post. I am not sure I even understand the original ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |