I gather this has been asked before, but I searched and couldn't find what I needed and I'm in a bit of a hurry, so sorry if I ask again.
I have an excel file, consisting of 5 columns all filled with data. I need to convert that into ASCII text with pipe delimited columns and I don't know how to do that.
The excel file looks like this attaced file: example excel sheet.jpg
and the pipe delimited columns have to look like the attached file.Example pipe delimited columns.jpg
I hope it's just a simple task, because I don't know anything about macros etc. Or if someone is willing to make it for me, I can send the entire file (I think it's about 2mb because it contains 25.000+ sheep). But I need to make two actually, one for each breed of sheep we have in the pedigree book.
Last edited by Titia; 01-31-2012 at 09:33 AM.
Assume your data is in columns A to E, then you can put this formula in, say, G1:
=A1&"|"&B1&"|"&C1&"|"&D1&"|"&E1
Then copy this down. Highlight all the cells in that column then click on <copy>, then right-click and choose Paste Special, then Values, then click OK and <Esc>. This will have converted the formulae to values, so now you can delete columns A to F, and then use File | Save As to save the file with a different name and with file type TXT.
Hope this helps.
Pete
Hi Pete, thanks for the explanation. In the meantime I have found an other way to do it.
In the control panel/Region and lanuages choose advanced and then set the list seperator to what sign you want to use, I took the pipe |
After that open the excelfile and save it as a CSV(Ms-dos). Then open the file in Notebook and save it as a text file and there it is.
Took me almost all night to find it, but I found it on the internet export excel files with pipe/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks