openoffice conditional formatting literal strings

Almost every line has what you're looking for (and I think the rest would have as well, but got truncated) I've looked at the data for a bit, and there's a few things I can say about it. It would help be just to find the cells out of the 16k that contain strings less *or more* than 9 characters.ĭoes conditional formatting work on cells that are super full because i've found find and replace is broken and can't read cells that literally contain too much data. It's impossible to tell at the moment if i'm making progress because of these errors or even if I've created more errors. I check the text to columns sheet and PowerQ combined 2 strings that were in adjacent cells. I've been using text to columns delimiter space then power query.įirst column selected, Unpivot other columns to get all these different strings in a 1 column list, then checking the (Len) length.īut I've realised the power query method is creating errors for some reason. I need to delete these strings that are not 9 characters long but I need to find them first. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified

Only text posts are accepted you can have images in Text posts.

Use the appropriate flair for non-questions.

Post titles must be specific to your problem.

Openoffice conditional formatting literal strings