Numbers in different areas on page?

[z12ent]

Hello I have a question? In Excel I have list of the same numbers but in different areas on my sheet. Example 1 2 3 4 5. Now if I wanted all the 1's to change to 6 in place of 1 what formula would I use rather than going through the entire page changing all the 1's to 6's? Thank you for your time.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...as-page-part-2-a-post5188179.html#post5188179

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).