I am trying to run a find and replace type macro on my spreadsheet. I want to find a cell in a column based on part of the cell contents and change it something else. Example: In a column I have RB 603,RB 512, RB 15, TOE17, HAND 01.
I want to go down the column and replace all of the RB's with the number 603 without specifing each value that could possibly show up (thousands of possiblilties).
Thanks,
Clayton
I want to go down the column and replace all of the RB's with the number 603 without specifing each value that could possibly show up (thousands of possiblilties).
Thanks,
Clayton