Find and Replace All

' Use the following macro to find all occureneces of "OLD TEXT" and replace it with "NEW TEXT";

Sub MyOffset()

With Range("A1:Z100")

  Set Rng = .Find(What:="OLD TEXT", LookAt:=xlWhole, LookIn:=xlValues)

  If Not Rng Is Nothing Then

    firstAddress = Rng.Address

    Do

      Rng.Value = "NEW TEXT"

      Set Rng = .FindNext(Rng)

    Loop While (Not Rng Is Nothing) Or (Rng.Address <> firstAddress

  End If

End With
End Sub

List of ALL Excel Functions/Formulas

For Excel 2007 -
Visit http://office.microsoft.com/en-us/excel/HP100791861033.aspx

For Excel 2003 -
Visit http://office.microsoft.com/en-us/excel/HP052042111033.aspx

How to learn more about Excel

Websites:

I love a few sites and owe a lot to their creators...

Chip Pearson - http://www.cpearson.com/excel/MainPage.aspx
Debra Dalgleish - http://www.contextures.com/

but the best way is to take a problem and try to solve it... you will learn a lot in trying to answer posts in this forum...

Books:

Excel 97 through Excel 2007 From MrExcel

Download a free preview copy from http://www.mrexcel.com/learnexcel2.shtml

This should be more than enough for now...

Last but not the least - use Google search... (or any other search engine of your choice)