Forum Discussion
Convert Text to Columns Wizard
Is it possible to create a macro or some function to quickly or automatically convert text to columns? Every day I receive via email, a csv file with 8000+ pieces of data. Thanks Mark
Excel already has a lot of options built-in during the import/open function. I'm guessing those tools either don't work or you want something that is more automated. In answer to your question, yes, cell formulas and macros/VBA can do that, but we can't help you without specific data and information.