Hello everyone and thank you for reading my post.
Here is my situation and what I am attempting to accomplish.
I have a sheet with somewhere around 2700 numbers that need to be found and replaced across 4 columns.
Example of the numbers, left is the Find and the right is the Replace.
34000 to be found 29232 to replace 34000 in sequential order 2700 times.
So essentially across the 4 columns I need to find that left number and replace with the right number, 2700 specific numbers in total.
How can I use a formula to do this at one time rather than spending an entire day using the basic Find and Replace function.
Thanks, RC.
Bookmarks