When downloading data from an ERP into Excel, a Remarks column has entries which can be as lengthy as 300 characters per cell. Before uploading this data into another database, entries in the Remarks column need to be split into multiple cells of upto 50 characters per cell. Furthermore, when splitting data into multiple cells, it should be ensured that no word gets split/broken. So if the 50th character is alphabet k of the word Like, then that cell should hold words till the word which appears just before Like so that the length does not exceed 50 characters.
You may refer to my solution in the attached workbook.
Extract specific number of characters from an alphanumeric string without breaking any word
{ 4 Comments }