I have a 1500 row spreadsheet. Column D containes text I want to query on.
Some of the text strings are as 800 characters. Autofilter "contains" wont
catch these words. I have embared on a process of inserting additional rows
and breaking up the text to ensure no longer than 255 characters in any one
cell. For example, say Cell D376 contained 750 characters, I would insert
new rows 377 and 378 and. Cell D376 would contain first 255 characters,
Cell D377 would contain characters 256 to 509 and cell D378 would contain
characters 510 onwards.

In practice I truncate at end of sentences, so might not be exactly 255
chars in each cell.

Can anyone advise me how I can speed this manual insertion up.

TIA

Gerry.

You may want to try the technique at Debra Dalgleish's site:
http://contextures.com/xlautofilter02.html#String



Gerry wrote:
>
> I have a 1500 row spreadsheet. Column D containes text I want to query on.
> Some of the text strings are as 800 characters. Autofilter "contains" wont
> catch these words. I have embared on a process of inserting additional rows
> and breaking up the text to ensure no longer than 255 characters in any one
> cell. For example, say Cell D376 contained 750 characters, I would insert
> new rows 377 and 378 and. Cell D376 would contain first 255 characters,
> Cell D377 would contain characters 256 to 509 and cell D378 would contain
> characters 510 onwards.
>
> In practice I truncate at end of sentences, so might not be exactly 255
> chars in each cell.
>
> Can anyone advise me how I can speed this manual insertion up.
>
> TIA
>
> Gerry.

--

Dave Peterson