Click the HomeEditingFind&Select icon, select Replace from the menu that appears, put fconews in the "Find what" field, pinetreeline in the "Replace with" field, click the Options button (note the two greater than symbols) to **open** the dialog box to show the options and make sure the "Match entire cell contents" Checkbox is **not** checked... then click the "Replace All" button.

--
Rick (MVP - Excel)


"Michael Koerner" wrote in message ...
Using Excel 2007. I have work sheet which has the following formula. I would like to change part of the location from
=HYPERLINK("C:\Data Files\WebPages\clickhost\fconews\locate\id_0143.ht ml", "0143") to read
=HYPERLINK("C:\Data Files\WebPages\clickhost\pinetreeline\locate\id_01 43.html", "0143")

Do I have to do all records one at a time or is there an easier way to do this?

--

Regards
Michael Koerner