Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display 1 line of multiple worksheets into multiple lines on 1 wks | Excel Worksheet Functions | |||
Condensing Imported fixed-width text with multiple data lines to one Excel row | Excel Discussion (Misc queries) | |||
How do I get multiple lines of text in a Excel cell? | Excel Discussion (Misc queries) | |||
Code for Inserting Multiple lines | Excel Discussion (Misc queries) | |||
Write code to insert multiple lines | Excel Discussion (Misc queries) |