Test-To-Columns 256
 

in VBA you can use the SPLIT function to parse the data into an array and
then transpose this into a sheet, so that you don't have that 256 column
limit. Unless of course you have more than that number of rows ...
"Otto Moehrbach" wrote in message
...
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?