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?