We're wondering if there is a way to get Excel 2007 to remember the previous Text to Column settings. We are receiving reports in an email that we copy into Excel. We run the Text to Column>Delimited>Delimiters (Only Other = |)(Text Qualifier left as default = *)>Column Data Format (General). Every thing works great and the columns are the way we want them. We go to another report, copy the data, go back to the same worksheet, go a couple of cells below, paste the data and we are back to having to run Text to Column again. Any way to have it remember the settings so it automatically enters the data in the correct columns?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!