Hi
Wondering if anyone has tried something like this before?
I am trying to 'transform' some transactional data from one ERP system to get it into another.
One of the columns I'm trying to transform is 'Description'. Unfortunately, on the old system, users were able to use carriage returns and the desciption, although appearing in one field, could be split over multiple rows.
In my Excel extract from the old system, all the text is captured nicely in one cell. However the carriage returns are there and the text is actually split across multiple lines in a cell.
My import routine can't handle this and will just cut everything off after the first carriage return (either that or it just errors, I can't remember).
Does anyone have a clever way of splitting a string of text in one cell by the carriage returns and making each 'line' appear on a separate row?
I have attached an example workbook with two worksheets. 'Data' shows what I'm dealing with and 'Formula' is what I'm looking for!
Many thanks in advance
Tom
Bookmarks