How to Replace Values in Excel

Using Excel on a Computer

Open your workbook in Excel. You can open your project by clicking the File menu and selecting Open. You can also open it by right-clicking the file and selecting Open With > Excel. This method should work for all versions of Microsoft Excel beginning with Excel 2007.

Click the Home tab. You'll find this in the editing menu above your document.

Click Find & Select. You'll find this in the "Editing" grouping of the Home tab with the icon of a magnifying glass.

Click Replace. This is usually the first listing in the drop-down menu.

Enter the original value in the "Find what" text box field. This is the text that will be replaced. You can use * to find a string of characters. For example, s*d will find "sad" as well as "started." You can use ? to replace a single character in a search. For example, s?t will find "sat" and "set."

Enter the new value in the "Replace with" text box field. This text will replace the original text. You can opt to match the case, so you can change every instance of "wikihow" to "wikiHow." You can chose to contain your find and replace to the current worksheet or apply it to the entire workbook.

Click Replace All or Replace. If you want to decide to replace each original value individually, choose Replace, but if you want to replace all the original values at once, choose replace all.

Using the Excel Mobile App

Open your project in Excel. This app icon looks like a green-and-white spreadsheet icon with an "X" next to it. You can find this app on the Home screen, in the app drawer, or by searching. If you don't have the Excel app, you can get it for free from the App Store (iOS) and the Google Play Store (Android). Tap the Open tab in Excel to find all your recent documents.

Tap the search icon Android 7 Search that looks like a magnifying glass. You'll see this in the top right corner of your screen. A search bar will appear at the top of your document.

Tap the gear icon Android 7 Settings. You'll see this next to the search bar that dropped down. Search options will appear.

Tap to select Find and Replace or Find and Replace All. As you tap an option, you'll see the search bar at the top of the screen change to fit your selection. Tap Find and Replace if you want to replace each original value individually. Tap Find and Replace All if you want to replace all the original values instantly.

Tap Done (iOS) or X (Android). You'll see this option at the top right of the search settings.

Type your original value into the "Find" bar. This is the current value located in your document.

Type the new value into the "Replace" bar. This value will replace the current value in the document.

Tap Replace or Replace All. You'll see this with your "find and replace" terms.