I have been given the daily responsibility of importing into Excel a mainframe text file to format and distribute to the sales staff. Most of the data in the text file imports into one cell on one row, with the exception of the part number description which unfortunately comes into Excel as two rows because the mainframe has the description formatted into two rows. Is there method to combine the two row description into one cell? As an example, the data would import as such:
Branch Year Part Description Ctn Qty
23 2009 12345 Brown-White Wire 2500
125 Volt 4 Lead
The description which imports into Excel as two lines needs to be combined into one cell with the associated data. I appreciate any assistance or suggestions.
Thank you
Branch Year Part Description Ctn Qty
23 2009 12345 Brown-White Wire 2500
125 Volt 4 Lead
The description which imports into Excel as two lines needs to be combined into one cell with the associated data. I appreciate any assistance or suggestions.
Thank you