![]() I do not see how you would do this using the technique I posted. This is likely to easily run up against the string limit size of 32,767 since if even 5% of those cells have just a single character, you will have 14,250 characters plus a nearly equal amount of separators. Thinking about this last night, I think getting to one concatenated string based on 3000 rows of data with up to 95 columns may be impossible. Obviously, this is a bit simpler if your keywords have no spaces, but that was not stated. Then it replaces the remaining spaces with "|" and puts back the initial spaces by substituting a space for any "~". The formula looks for existing spaces and replaces them with an unused character (in this case, I used a "~"), then it replaces "|" with a " " and uses the TRIM command to eliminate leading and ending spaces as well as excessive spaces in between. Where the series starting with A7 and ending with DM7 would be replaced with the concatenation you have with multiple "|" symbols. I never found something I liked, but used several different methods as I changed my preferences over time. ![]() I ran into this years ago when I was trying to create lists of potential racing picks from a list of horses in a race.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |