Région de recherche :

Date :

https://support.microsoft.com › en-us › office › find-or-replace-text-and-numbers-on-a...

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 replace it with something else.

https://www.exceldemy.com › excel-find-and-replace-within-selection

How to Find and Replace within Selection in Excel (7 Methods)

Method 1 – Find and Replace in Selected Cells Only. To demonstrate, let’s find and replace the value of cell B7 containing the text Smith. Steps. In the Find what box of the Find feature, type Smith as shown. Select the Find All. The cell location $B$7 is returned. Select the Replace tab (or press CTRL + H) and type Steve Smith.

How to Find and Replace within Selection in Excel (7 Methods)

https://www.ablebits.com › office-addins-blog › excel-find-replace

Using Excel Find and Replace in the most efficient way - Ablebits

Learn how to use Excel Find and Replace to search for specific text or numbers in a worksheet or in all open workbooks. See how to use wildcard characters in search criterial, find cells with formulas or specified formatting and more.

Using Excel Find and Replace in the most efficient way - Ablebits

https://support.microsoft.com › fr-fr › office › rechercher-ou-remplacer-du-texte-et-des...

Rechercher ou remplacer du texte et des nombres dans une feuille de ...

Pour remplacer du texte ou des nombres, appuyez sur Ctrl+H ou accédez à Accueil > Modification > Rechercher et Sélectionner > Remplacer. Remarque : Dans l’exemple suivant, nous avons sélectionné Options >> pour afficher l’intégralité de la boîte de dialogue Rechercher.

Rechercher ou remplacer du texte et des nombres dans une feuille de ...

https://www.exceldemy.com › excel-find-and-replace-in-column

How to Find and Replace in an Excel Column (6 Methods)

Steps. Press the keyboard shortcut CTRL + H or navigate to Home, select Editing, choose Find & Select and click on Replace. In Find what box enter the text you want to find for replacement. In the Replace with box enter the replacement text (e.g., replace Chips with Crackers).

How to Find and Replace in an Excel Column (6 Methods)

https://www.ablebits.com › office-addins-blog › excel-replace-substitute-functions

Using Excel REPLACE and SUBSTITUTE functions - formula examples - Ablebits

The REPLACE function in Excel allows you to swap one or several characters in a text string with another character or a set of characters. REPLACE (old_text, start_num, num_chars, new_text) As you see, the Excel REPLACE function has 4 arguments, all of which are required.

Using Excel REPLACE and SUBSTITUTE functions - formula examples - Ablebits

https://spreadsheeto.com › find-replace

How to Use Find and Replace in Excel: Full Guide (2024) - Spreadsheeto

Find and Replace is one of the most common yet most resourceful features of Excel. Searching through hundreds of thousands of rows is definitely not the best thing to do. And to replace something within these rows is even worse. So Find and Replace lets you find a particular word or phrase in seconds regardless of the volume of the data.

How to Use Find and Replace in Excel: Full Guide (2024) - Spreadsheeto

https://www.howtogeek.com › 442859 › how-to-find-and-replace-text-and-numbers-in-excel

How to Find and Replace Text and Numbers in Excel - How-To Geek

Select the range of cells you want to find and replace in or click any cell to search the entire active worksheet. Click Home > Find & Select > Replace to open the Find and Replace dialog box. Select the "Options" button to expand the Find and Replace options.

How to Find and Replace Text and Numbers in Excel - How-To Geek

https://www.xelplus.com › excel-find-and-replace

How to Find and Replace in Excel - Xelplus - Leila Gharani

Find and Replace in Excel can help. It lets you change words, numbers, and even adjust formatting across your entire workbook efficiently. This feature is a quick solution for correcting typos or updating cell references in bulk. Or, with just a few clicks, you can alter text styles and cell colors throughout your document.

How to Find and Replace in Excel - Xelplus - Leila Gharani