|I use a system that spits out a spreadsheet every day, but the data in each cell has brackets around it. |
Cell A1: 
Cell A2: 
Cell A3: 
To make them easier on the eyes, I use Excel's inbuilt REPLACE function, and tell it to Replace All left brackets with nothing, then the right brackets with nothing. But that takes multiple keyboard commands/mouseclicks, and is grossly inefficient. The system itself CANNOT BE CHANGED and must include these brackets to ensure the numbers come out properly, so what I would like is to be able to press, say, F2, and have it automatically remove all instances of [ and ].
I've used AutoHotKey for certain hotkeyed shortcuts, but I don't know how to do this one. I asked on their forums, and they said that AutoHotkey is overly complicated for such a simple Excel macro, and "It might be easier to use a RegEx replace within Excel and create an Excel macro to run it. Or even without using the RegEx option of Excel's replace, just make an Excel macro to execute the two separate replaces that you currently do."
I tried googling this, but have found no "How to delete multiple characters in Excel with one key [SOLVED] thread, or similar. Can anyone help?