![]() I have several cells that contain, , and so on. Is there any way I can get this exact functionality within Excel 2013? I have used it successfully in Word 2013 (thanks to this helpful article), but Excel seems to take my “replace” text as a literal string and will not parse my expression properly. Change the number of spaces after a period:.Find and replace any number of spaces:. ![]() \3 - Tells Word to replace the third element of the Find with what was in the Find (the closing square bracket).Īs with the Find elements, there are no spaces between these elements.In other words, keep the exact text as was found, but change it’s font size and color. \2 - Tells Word to replace the second element of the Find with the same text as what was found.\1 - Tells Word to replace the first element of the Find with what was in the Find (the opening square bracket).There are no spaces between any of these elements - the aim is to find a string such as and replace it with exactly the same text but formatted in a different color and with a difference font size. above), the closing square bracket is a special wildcard character, so needs a backslash in front of it for Word to treat it as ordinary text, and it needs to be enclosed in parentheses as it’s an exact match you want. (\]) - This tells Word to stop the find at the first closing square bracket it finds after an opening square bracket followed by any other characters.There’s no limit on what sort of characters (alpha, numeric, or symbols) Word is to find, or on how many there are. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |