I’m trying to make a macro to assist me with my football pool. What I’d like to do it is have the macro look for the text in a portion of a cell, and then replace the entire cell with new text. For example, column A might have the following:
Game_1: @New England (1-0)
Game_2: @Atlanta (0-1)
Game_3: @Buffalo (0-1)
Game_4: @Chicago (1-0)
Game_5: @Green Bay (0-1)
Game_6: @Indianapolis (1-0)
Game_7: @Kansas City (1-0)
Game_8: @Baltimore (0-1)
Game_9: @Houston (1-0)
Game_10: @Philadelphia (1-0)
Game_11: @Arizona (0-1)
Game_12: @Tampa Bay (0-1)
Game_13: @Oakland (0-1)
Game_14: @NY Giants (0-1)
Game_15: @Seattle (1-0)
Game_16: @Cincinnati (0-1)
TotalScore: 22
I’d like for the macro to search for “England”, and then replace that entire first cell with “NE”. Then search for “Atlanta”, and replace that entire cell with “ATL”, and so on down the line.
Here’s the problem – when using the Find & Replace tool, you have the option to “Match entire cell contents”. If I have that checked off, then searching for “England” brings back no results (since there is more than just the word “England” in the cell). But if I don’t check it off, then the cell “Game_1: @New England (1-0)” becomes “Game_1: @New NE (1-0)”.
Anyone have an idea how I can make the “Match entire cell contents” command only apply to the “replace”, but not the “find”?