# Search and replace

1. ## Search and replace

Hi all,
*
I´ve made the formula below for a weekly followup worksheet, the formula is therefor present in 52 sheets and I need to remove the "week part" from the formula. Thing is I have from week 1 to week 52, the rest of the formula is the same.
*
how do I remove the highlighted part without having to go through all 52 sheets?
*
=(IF(F7="";0;F7-E7)+IF(F9="";0;F9-E9)+IF(F11="";0;F11-E11)+IF(F13="";0;F13-E13)+IF(F15="";0;F15-E15)+IF(F17="";0;F17-E17)+IF(F19="";0;F19-E19)+IF(F21="";0;F21-E21))-'week 1'!K6
*
xlsmNewbie

2. ## Re: Search and replace

CTRL-H

Find: -'week 1'!K6
Replace: (nothing)
Within: workbook
Replace All

3. ## Re: Search and replace

@Glenn, I think that his references are like week1, week2, ...., week 52, so is not gonna work with Ctrl+H.

@xlsmNewbie, try the solution found here: https://stackoverflow.com/questions/...e-for-formulas

4. ## Re: Search and replace

Yea. You're probably right!!

5. ## Re: Search and replace

Glenn, Just as Paul mentioned the sheets are named from week 1 to week 52, otherwise as you posted ctrl-H would´ve worked

Paul, Thank you for the link, I looked into it but found a simpler way. By ctrl + selecting each sheet with the formula present I could change the formula in the first sheet and they would change in the other 52 aswell. The sheets do need to be identical though, which luckily they are.

6. ## Re: Search and replace

There are currently 1 users browsing this thread. (0 members and 1 guests)