Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test-To-Columns 256
Excel XP & Win XP
With VBA, I need to break down large cell entries (more than 256 words) into individual words. Text-To-Columns works only for 256 words because of the 256 column limit in Excel XP. Is there a work-around to place the words into a column rather than a row? Thanks for your time. Otto PS: My objective is to have VBA work with each individual word. Is there another way for VBA to capture each individual word? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Test-To-Columns 256 | Excel Programming | |||
Test-To-Columns 256 | Excel Programming | |||
TEST for items in 2 columns to MATCH? | Excel Discussion (Misc queries) | |||
Trying to test several columns for changes when entering data | Excel Programming | |||
Sum one column after capmaring test from teo more columns | Excel Worksheet Functions |