Wingding Font Face Characters. Last Update: 03 August 2018. Wingdings characters 0-9, A-H. Wingdings characters Alt-0128 through Alt-0143. For an unhappy face, it’s a capital L formatted in the Wingdings font. The following basic Excel skills demonstrates using this technique to display a happy or unhappy face dependent upon someone’s exam grade. The exam grade is in cell B3 and the smiley face will be inserted into cell C3. Click in cell C3.
Posted by Mark McGrath on February 07, 2002 1:08 AM
I want to be able to display in Excel a smiley face depending on performance (e.g. Good performance=Happy Face, Poor performance=Sad Face). I know that the 2 smiley face images are available with characters J & L using the Wingdings font, but to be consistent with other methods of input I want the users to type in 1 for Good and 2 for Poor, rather than J and L.
Is there any way, maybe with a user-defined font, of typing in 1 & 2 and being able to return J & L in the same cell to give me the smiley face image without using a macro.
Is there any way, maybe with a user-defined font, of typing in 1 & 2 and being able to return J & L in the same cell to give me the smiley face image without using a macro.
You can do this by using an IF statement.
Say you want to insert 1 or 2 into a cell in column A and the have the smiley returned in column B. What you do is, in the cell in column B type; =IF(A1=1,'J',IF(A1=2,'L'<)). Now select all the cells where you want the smiley returned and change the font to wingdings 1. Note that the J and L in the statement must be in capitlals.
Say you want to insert 1 or 2 into a cell in column A and the have the smiley returned in column B. What you do is, in the cell in column B type; =IF(A1=1,'J',IF(A1=2,'L'<)). Now select all the cells where you want the smiley returned and change the font to wingdings 1. Note that the J and L in the statement must be in capitlals.
Hope this has helped.
Use Conditional Formatting [nt]