I wanted to know if anyone knows of a way to edit columns. More specifically I have 3 columns of data in Notepad. One of these columns contains zip codes. I want to import the data into Excel. Once their I want to edit the zip code field so that this data does not contain the plus 4 data on the end of the zip code. In other words is their a way to take a column of zip codes that contain the zip code(11123-4564) and use a function or formula that could edit it to (11123)?