I have a column of data called (Desc). This data was imported out of QuickBooks (QB). QB would allow up to 255 characters on one line. I have to import this data into another software, which will only allow 60 characters per line.
I would like to know, is it possible to run a macro or formula or other option that would scan each row of data and break that data line after 60 characters and then insert a empty cell (same column) below the original cell and insert the remaining data up to 60 characters.
I cannot bring in the data if the line break's remaining data is moved to another column. They have to stay in the same column and I have to tag two identifiers to them so they get imported to the correct customer file.
I am using Excel 2013 on Win 7 Pro box.
I have uploaded an example of the Excel file, but I am having trouble attaching it to this thread. I will get it on it asap.
Thank you for anyone taking time to review my thread.
Crw
Bookmarks