Step-by-Step 1 – Open a Non-Native File Directly in Excel

Excel will now hide any duplicate records in the selected range. ... It allows you to specify a target value for a cell and tell Excel to change the value of another related cell to obtain this value. ... enter an apostrophe ['] before the value. In this case, typing '08053 formats the cell as the text value 08053. ................
................