Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi NG
I need to split cells with text strings. Max Splitting length is normally between 20 and 40. If a words length is greater than 'Max Splitting length', then I want a warning. Splitting to next cell in row example A "This is a test for splitting a text to max length on 22." 1: This is a test for 2: splitting a text to 3: max length on 22. example B "attacks against small_medium_and_large-sized organizations." 1: attacks against 2: small_medium_and_large-sized ** and warning** 3: organizations. Any suggestion / proposal are welcome. -- Best regards from Joergen Bondesen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Splitting Text | Excel Discussion (Misc queries) | |||
Splitting Text? | Excel Discussion (Misc queries) | |||
Splitting text | Excel Discussion (Misc queries) | |||
Split Long Text Cell into Two Shorter Cells Without Splitting Word | Excel Discussion (Misc queries) | |||
splitting and rejoining text in cells | Excel Worksheet Functions |