If this means that you have been importing multiple files that should have the same structure then you need to take control of how you read data at the beginning. A "column" should have the same properties. Unfortunately Excel enforces no rules on any cell, much less entire columns.
Search the forum for IMPORT and EXCEL. This is such a common problem we answer some form of it nearly daily, if not multiple times per day.
... View more