Excel 2013 Tutorial For Noobs Part 25: How to Find & Replace Content Numbers & Formulas in Excel

http://www.excelfornoobs.com

In this Excel for beginners tutorial I teach you how to search find and replace content, numerical values and formulas in a cell or multiple cells. You can do this by using the Find and Select command.

In Excel you can locate cells by using the Find and Replace command. Suppose you wanted to locate a cell or all cells that contained a certain word or number. Instead of searching throughout your worksheet you could use the Find and Replace command and let Excel do the work for you.
Find In the Home tab under the Editing group click on the Find & Select command and from the drop-down menu click on Find and the Find and Replace dialog box will appear. The Find and Replace dialog box has two tabs, the Find tab and the Replace tab. Where it says "Find What" enter the content that you want to locate. Now click on the Options button and more search options will appear in the dialog box. Here you have options of Within, Search, Look in, Match case and Match entire cell contents. Use the options to tailor your search and press Find All.




find and replace in excel 2013 Within: Here you can choose to search a single worksheet or the entire workbook. Search: Here you can organize your search by rows or columns. If you were to choose By Rows then your search results would be organized by rows. The very next cell in the search would be the very next cell in the row that contained your data. If you organized your search By Columns then the very next cell in your results would be the next cell in the column that contained your data. Look In: Here you can choose to search inside formulas, comments are regular values for the data you want to locate. Match Case: If this box is checked then your search will be case sensitive. Match entire cell contents: If this box is checked then the cell or cells found must contain on the search string and nothing else.

Replace
Imagine you had a large inventory list with the names of multiple suppliers. What if one of the suppliers changed their company name? It would be very time consuming to change the company name cell by cell. Instead you can use the Find and Replace command and change all cells instantly. In the Find and Replace dialog box make sure the Replace tab is activated. The only difference with the Find tab and the Replace tab is that you have a new box and buttons that allow you to replace the cells in your search results with other content. The options work the same in Replace as the do in Find. Make sure that you use the Match Case and Match entire cell contents if necessary. If you searched and replaced the number 3 with 5 without checking the Match entire cell contents option then the number 2 would be replaced with the number 5 even if it was in a series of numbers. For example, 638 would be 658 after you click Replace All or Replace Next.


This tutorial works for Microsoft Excel 2007, Excel 2010 and Excel 2013

https://www.youtube.com/user/Subjectm...
https://www.youtube.com/watch?v=aKUIC...

---

Closed Caption:

and this tutorial I'm going to show you
how to search find and replace content
in Excel Excel you can locate cells by
using the find and replace command
suppose you want to locate a cell or
cells that contain a certain word or
number instead of searching throughout
your workbook you could use the
find/replace command and let Excel do
the work for you
first we'll cover how to find content
and the Home tab under the editing group
click on the find & select command and
from the drop-down menu click on fine
and the Find and Replace dialog box will
appear the final place dialog box has
two tabs the fine tab and the replace
tab where it says find what end of the
content that you want to locate now
click on the options button and more
search options will appear in the dialog
box here you have options of within
search look and match case and match
entire cell contents use the options to
tailor your search and press find all
the within option here you can choose to
search a single worksheet or the entire
workbook the search option here you can
organize your search by rows or columns
if you were to choose my rose in your
search results would be organized by
Rose the very next cell and the search
would be the very next cell and the
rather contain your data if you organize
your search by columns in the very next
cell in your results would be the next
cell in the column that contain your
data the look and option here you can
choose to search inside formulas
comments and regular values for your
data you want to locate the match case
option if this box is checked in your
search will be case sensitive match
entire cell contents if this box is
checked in the cell or cells found must
contain only the search string and not
else how to replace content imagine you
had a large inventory list with the
names of multiple suppliers what if one
of the suppliers change your name it
would be very time-consuming change the
company name cell by cell instead you
can use the Find and Replace command and
change all cells instantly in the
find/replace dialog box make sure that
the replace tab is activated the only
difference with the fine tab and the
replace tab is that you have a new box
and buttons that allow you to replace
the cells in your search results with
other content the options work the same
and replace as they do and find make
sure that you use the match case and
match entire cell contents if necessary
if you searched and replaced the number
three with five without checking the
match entire cell contents option than
the number two would be replaced with
the number five
even if it was in a series of numbers
for example the number 638 would be 658
after you click replace all or replace
next