Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer 1

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.

Find Replace before replace Find Replace after replace

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.

share|improve this answer
    
Ha, I can't believe I didn't think of the simple find and replace. Thanks! –  Pteryx Apr 20 '12 at 18:17
    
You're welcome! –  rishimaharaj Apr 20 '12 at 18:19
    
Also, would there be a way to have it replace text as it comes up? Say, I type in "7s" and it immediately switches it out for the circled 7. –  Pteryx Apr 20 '12 at 18:19
    
I don't think this feature is as advanced as that. But, there are dropdowns to select previously entered values: if you had already typed in "circled 7", "circled 6", and "circled 5", you could click the dropdown and select whichever you want from there. –  rishimaharaj Apr 20 '12 at 18:22
    
I'll check that out. Thanks again. –  Pteryx Apr 20 '12 at 18:25
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.