Hi,
I have a bunch of files that I have extract data from everyday. However, I need to use the "text to column" function before I could sort the file. I would like to create a macro to help me do the job so then I don't have to do it everyday. Is it possible to write a "text to column" macro? if so, how can I do that? Please let me know. Thank you very much.