answersLogoWhite

0

You can use this feature to find and replace any string (text and/or numbers) or portion of a string in your spreadsheet. However, exercise a little caution as you can potentially alter something you didn't intend to!

See the excel help file for further information.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

How do you 'search and replace' in Excel?

Click CTRL+F to prompt the Find dialog box which also has a tab for Find and Replace.


How do you replace all text all at once in Microsoft Excel?

The Find and Replace option can be used to replace text in Excel. A particular piece of text can be replaced throughout the document using Replace All. Use Ctrl - H to activate the Replace option in Excel.


How do you replace 2011 with 2012 in multiple columns in excel?

Use Find and Replace.


In Excel can you quickly find and open a worksheet?

Yes. You can search for Excel files and then open them. There is a Search option in the Open dialog box. You can also simply browse through folders where you have your files and find and open them.


How do you replace words?

Assuming the question is for computers, on Excel go to Edit then click on Replace. A box appears with Find what: Replace with: so fill in those two boxes then click on Replace.


How to replace timing belt 96 Hyundai excel?

how ofen do you change a timing belt on 96 excel


Did Excel replace Lotus 1-2-3 or are they rivals?

rivals


Which function is similar to the Find and Replace feature in excel?

the SUBSTITUTE function


How do you replace plug leads on Hyundai Excel 1998?

Take it to a mechanic


How do you replace all occurrences of the word exhibits with the word shows in Excel 2003?

Press Ctrl - h to open the Find and Replace facility. Put exhibits into the Find what box and exhibits into the Replace with box. Then click Replace All.


Which menu contains the Find and Replace commands when using Excel?

The Edit menu.


What are the two text boxes found in the Replace tab of the Find and Replace dialog box?

The first text box (the "find" box) is where you type the string you wish to search for. A string is just any combination of characters and/or numbers. The second box is the replace box. This is where you type what you would like entries matching the search to be replaced by. So, for example, imagine you had the word "timmy" in your spreadsheet. Imagine that it appeared many times, in various places, and you wanted to change it in every instance so that it read "Timmy" (with a capital T). You could type "timmy" in the find box and "Timmy" in the replace box and then choose "Replace All". To avoid unwanted mistakes here, such as replacing something you didn't intend to, it is advisable to read the Excel help article on this feature before using it (or at the very least save a backup copy of the unaltered workbook first).