| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Split Long Text Cell into Two Shorter Cells Without Splitting Word
I have text cells that are up to 60 characters in length that I need to break
into 2 separate cells, each cell can be up to 30 characters long without splitting up any words. So, if the 30th character splits a word, it should split to the second cell at the previous space. How do I set up a formula to do this? I figured that if I wanted the first 30 characters, I could use the formula (if the text was in A1) =LEFT(A1,30). But this splits any words. Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I break up a long text cell into shorter ones withoug s | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| advanced filter - can't match a long text cell | Excel Discussion (Misc queries) | |||
| On click, copy text into another cell - XL2K | Excel Worksheet Functions | |||
| Help adding text values | Excel Worksheet Functions | |||
Threaded Mode
