Autofilter limit of 255 - breaking up longer text strings - How to do it quickly

G

Gerry

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top