
REPLACE function - Microsoft Support
In workbooks set to Compatibility Version 2, REPLACE has improved behavior with Surrogate Pairs, counting them as one character instead of two. Variation Selectors (commonly used with emojis) will …
Replace Function - Microsoft Support
The return value of the Replace function is a string, with substitutions made, that begins at the position specified by start and concludes at the end of the expression string.
Find and replace text in Word - Microsoft Support
You can find and replace text with special formatting, such as bold or highlight, by using the Format menu. On the Format menu, select the replacement formatting. If a second dialog box appears, …
Find or replace text and numbers on a worksheet
Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can …
Video: Find and replace text - Microsoft Support
If you’re working with a lot of text and need to search and replace a word or a phrase, use Find and Replace in your Office app. Select Replace or press Ctrl + H.
Find and replace text - Microsoft Support
Select Find and Replace. In the Find What box, enter the text you want to search for, and in the Replace With box, enter the text you want to use as the replacement.
SUBSTITUTE function - Microsoft Support
This article describes the formula syntax and usage of the SUBSTITUTE function in Microsoft Excel. Description Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to …
Find and replace text in notes - Microsoft Support
OneNote doesn't currently support an automatic search and replace, but you can use instant search to find specific text and then replace it manually using a keyboard shortcut.
Find and replace text within an email message or item
Find and replace text, formatting, paragraph marks, page breaks, and more within an open Outlook email message.
Replace a formula with its result in Excel - Microsoft Support
When you replace formulas with their values, Excel permanently removes the formulas. If you accidentally replace a formula with a value and want to restore the formula, select Undo immediately …
REGEXREPLACE Function - Microsoft Support
The REGEXREPLACE function allows you to replace text from a string with another string, based on a supplied regular expression ("regex"). The REGEXREPLACE function replaces strings within the …