So, I keep a spreadsheet of all of my bowling scores and how I do on each frame. To show that I got a split, I use "#s", where # is how many pins I knocked over, but I want to replace all of these with characters like ②, which would have the respective # in the circle. I have tons of scores in my spreadsheet, so changing everything by hand would take ages. Any advice?
Tell me more
×
Super User is a question and answer site for
computer enthusiasts and power users. It's 100% free, no registration required.
|
|
|
This is assuming that you are using Excel 2007 or newer. You can use the keyboard shortcut Ctrl-H to perform a find-and-replace (hold Control (Ctrl) on the keyboard, and press H at the same time). In the "Find what:" box enter your #s (such as 2s) and in the "Replace with box:" paste in your circled # (②). Click the Replace All button.
Note, you will have to do this per #. For each #, you must already have the circled character. You will have to repeat this exercise per sheet in the workbook. |
|||||||||||
|
