Hello Guys,
I have a text file with tab delimited data (150 lines) that i want to convert to space delimited or fixed length columns. I have tried to export the file using Excel's .prn format but when opened in MS Notepad it loses all formatting.
Let us consider the file as:
Now what is want is this:
I have used this tool and it does the job but again when saving in MS Notepad, the columns are misalinged and i want the data only in Notepad...
P.S. Is there anyway to do it using any tool that works in Notepad..EXCEL.CMD.SHELL.
Thanks in Advance...!
Bookmarks