Selected Answer
Don't put the symbol in the same cell as the name. Even if you manage to get the exact look that you want with this symbol, it will not be easy to maintain in the future or keep exactly how you want.
Instead, use conditional formatting and keep the star in its own column.
- Add a new and empty column next to the name.
- Input a star into the first cell of the new column.
- Insert tab > Symbol button (all the way on the right) > select a start from the list and click Insert once and then close the window.
- Make sure the cell with the star is selected and then go to Conditional Formatting - Home tab > Conditional Formatting > New Rule
- From the Rule Type box, select Use a formula to determine which cells to format
- Enter this formula for the female =$B1="female"
- This assumes that B1 is the first cell in the column of data.
- Click the Format button and choose the desired formatting for the cell.
- Repeat Steps 3-6 for the male but use this formula instead: =$B1="male"
- Hit OK to close the window and the copy the cell with the star and paste it down the column for the entire list of data.
This should get you the desired results.