by

Excel For Mac Find Special Characters

I can't find it either, but the following appears to work:

To find out what this character is, we can use the CODE function. Type this function into the cell B2: =CODE (LEFT (A2)). Since the character is in the first position in the text, we can easily find out its code using the LEFT function. In this case, we get the result as “160”. The first place to look for a special character is on the Insert Ribbon, using the Symbol button. The triangle next to Symbol shows you some of the most common and recently used characters in a drop down menu. The More Symbols button will bring up the character map built into Windows. You’re probably aware that you can find ASCII characters using numeric codes. For example, to find an e with an acute accent, you could do this: 1. Click the “Edit” menu. Click “Find.” 3. In the “Find What” box, enter ^0233 (on a PC) or ^0142 (on a Mac). Click the “Find Next” button. You can learn more about this here. Special character symbols from the set of Unicode characters like ☐, ☑, ⚐, ⚑, and can be useful for many different things in Excel. You can use them in drop-down lists, charts, custom number formats, dot plots and in-cell pictographs.

Excel Replace All Special Characters


  1. Turn on Show Invisibles in the View menu.
  2. Select (highlight) the double para breaks.
  3. Use Command-E (Find using selected text).
  4. Open the Find dialogue box (Command-F) and select Find & Replace.

    The selected para breaks will be in the Find text entry box, but will not be visible!

  5. Click in the Replace text entry box.
  6. Select (highlight) a single para break.
  7. Go to the Edit menu / Find and select 'Use selection for replace' (it will not show in the Replace entry box).
  8. In the Find & Replace dialogue box, click on the Forward or Back arrows to highlight the selected items (e.g. double para break) where you wish to start replacing in the document.
  9. Use the Replace All / Replace & Find / Replace buttons as per usual.


Excel Find Character Code

Not a nice solution, but I hope it gets you going until Apple restores the previous functionality!

Excel Find Special Character

Excel For Mac Find Special Characters

Oct 24, 2013 7:47 PM

Free Excel Crash Course. Learn Go To Special (F5) with CFI’s Free Excel Crash Course.This course gives you the most important spreadsheet formulas, Excel keyboard shortcuts (Mac and PC) Excel Shortcuts PC Mac Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions.