Looking for code to separate one line of text into multiple lines in Excel
I often need to manipulate a string of data, sometimes many hundreds
of records, (up to 125 characters) into multiple columns - usually five - for import into an application program. I've used split cell into columns function of Excel 2003 but it still requires some manual and semi-automated concatenation of resulting cells (up to 100+ per record!). I have an upper limit of 25 characters per new cell. I'd like to split text into the multiple columns without cutting off a word in the middle. e.g.: Original text: A long string that needs to be split into 5 adjacent cells of up to 25 characters and not splitting individual words Ideally, resulting text should look something like this (each line shown in separate row but actual result will be in same row, adhacent columns): A long string that needs to be split into 5 adjacent cells of up to 25 characters and not splitting individual word Note that last character in last line ("s" in"words") was truncated because it eceeded 25 characters. Any help would be appreciated. |
All times are GMT +1. The time now is 04:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com