#Where is find and replace in word 10 how to#
#Where is find and replace in word 10 code#

#Where is find and replace in word 10 code#

The string is Offer Code Text, then a comma. I'll drag the FindTheLetterB field back to Measures, and then go to Analysis, Create Calculated Field, and I'll say, 'ReplaceWithCF,' and press Tab. Specifically, I want to replace the TR code within the offer code text with the letters CF. Now let's say that I want to replace a value. Then for these three codes, it starts, or it occurs at the letter six, and then for these three it occurs at the letter four. I'll drag that over, and I see that for the first couple, it doesn't exist, so I get a zero. Now I can add the FindTheLetterB Field to my data area, because it's a measure, and it will display the position of the first letter B within each code. The calculation's valid, so I'll click OK. Then a comma, and the substring, which I'll put in quotes, is the capital letter 'B,' and I don't want to start past the first character, so I'll leave the Start argument blank. The function again is FIND, and the string that I'm operating on is Offer Code Text. I'll go to Analysis, and click Create Calculated Field, and I'll call it 'FindTheLetterB,' and then press Tab. I'll start by creating a Calculated Field that allows me to find the position of the letter B, within the offer code text, and it will be a capital B. I think we can all recognize the two that we want, 21% off and 23% off. I have the offer code text, and then also the amount of the discount. These are the codes that you can type into a website or give over the phone when you make a hotel reservation for a discount. In this Tableau workbook, which is the Find workbook that you can find in the Chapter08 Folder of the Exercise Files collection, I have a set of offer codes. With that information as background, let's switch over to Tableau.

#Where is find and replace in word 10 how to#

Finally, you have REPLACE, where you look for a substring within a string, and then replace it, and I will demonstrate how to use that. I couldn't think of a good use for FINDNTH, but I think it's a really cool function, so I wanted to mention it. For example, the FIND function would tell you the number of character at which the first L appeared, or FINDNTH would tell you where the third L appeared within a string for example. The next function is FINDNTH, which looks for a substring within a string, and it gives you the position of the Nth occurrence of a value. You could for example start with character number three. In other words, you don't have to start with one. The first function I'll mention is FIND, which takes a string, and then the substring that you're looking for, and you can also start looking at a character after the first. I will mention three string functions here and show you how to use two of them over in Tableau. I'll start in PowerPoint, and then move over to Tableau. In this movie, I'll show you how to find and replace data within the string. While sales values can be adjusted, you'll also find that some departments, products, and codes change as well. In this case, the only option you have is to dismiss the dialog box, as described earlier in this tip, and call it back up when needed by using Ctrl+H.- Business data can change quickly. If you are not using a high resolution, however, the ever-present dialog box could be a nuisance. If you have a large monitor set to a high resolution (which means you can see more information on the screen at one time) then this isn't a big problem the dialog box won't interfere with using the document. It should be noted that when you use Ctrl+Tab to switch between the Find and Replace dialog box and your document, the dialog box remains firmly planted in view, hovering over your document. Also, you will be returned to the exact cursor location in the dialog box that you were in when you toggled to the document. When you again press Ctrl+Tab to jump back to the dialog box, the find/replace operation will start from your new cursor location.

Once back in the document, you can scroll through the document or edit as necessary, while the dialog box is still there, grayed out. If you would rather toggle between the Find and Replace dialog box and your document, you can do so by pressing Ctrl+Tab. You can also press Ctrl+F4, or you can use Tab to select the Cancel button and then press Enter. I find the easiest way is to simply press Esc. If you want to get rid of the dialog box, there are three ways you can do it. Of course, pressing Ctrl+H displays the Replace tab of the Find and Replace dialog box.

Cheri asked if there is a way to close the Find and Replace dialog box using the keyboard, or, better yet, a way to toggle between the document and the Find and Replace dialog box using the keyboard.ДЄs with most commands in Word, there are keyboard commands you can use.