Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Replace
I am trying to update a worksheet that has multiple links to other workbooks.
The only problem is that the file locations are not in 2006\Dec\Frame Weld Cell 6 Dec 06.xls\, they need to be changed to read 2007\Jan\Frame Weld Cell 6 Jan 07.xls. Is there any way I can do this? The formula is too long to be typed in the find and/or replace section. PLEASE HELP!!! (Is there an easy way to do this without having to go through each and every cell in the worksheet?) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace | Excel Discussion (Misc queries) | |||
How to cancel a find & replace command "midstream"? | Excel Worksheet Functions | |||
Macro: Find and replace | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
VB Find and Replace | Excel Worksheet Functions |