I am little new to macros, i am trying to convert around 500 pipe delimited text file into excel so that in excel they appear in different columns.
example; text file 1|2|3
when converted , excel file should have 1,2,3 in column a,b,c.
I know its doable with little programming, but unable to do it as i am new comer.
Can any one please help with this.