Forum Discussion
Ryan_Angelos
Nov 22, 2022Copper Contributor
Find and Replace "all caps" not working
Hi all
I need to get rid of all "cells" (I believe they are actually "frames"? not sure) that contain all caps text. When looking for all caps text, i get this:
Am i doing something wrong? I get about 10 documents per week in which i need to get rid of all all caps text. Doing it manually is very time consuming. Am i doing something wrong or is there another way i can do this?
3 Replies
Sort By
- Charles_KenyonBronze Contributor
What you currently are searching for is font formatting of ALL CAPS. This is like Bold or Italics and is something changing the way something looks.If someone simply types with the Caps Lock key on, it will not see it because it does not have this font formatting applied.
What you need is a Wild Card search that looks for multiple upper case letters in sequence. While I may be able to come up with the syntax for that, I expect others may respond more quickly.
Here are some resources on this:
- Finding and replacing characters using wildcards
- Replace using wildcards by Graham Mayor, MVP
- The 2020 Guide to Using Word Wildcards
- Wildcard Cookbook for Microsoft Word: Jack Lyon
Are you trying to delete the text or just tone it down to not be in all caps?
- Ryan_AngelosCopper Contributor
Hi, I'm trying to delete all cells (or "frames") that contain all caps text. I already tried using the following wildcard;
<[A-Z]{2,}>
however, this only deletes the text itself and not the entire "cell", therefore leaving behind mostly empty cells with symbols (such as < > , . 🙂 still in them.
- Charles_KenyonBronze Contributor
First, you need to figure out whether these are table cells or Frames. They look like Table Cells to me.
Replace is not going to take out the table structure.
For a table, you are going to need a macro, which is beyond by skill level unless I wanted to spend a day or two on it. (Sorry, I do not wish to do that.)