Hi all,

Is is possible to find the ASCII characters in excel for a perticular
character?

I mean to say that, I need to insert a smiley in excel. I need this :)
and :( in excel. If I need a happy smiley, I can as well use ALT+1. But
if I need a sad one, I am not able to find it. Is there any combination
of characters which can give me that or is there a way to find it.

Thanks in advance,
Praveen


--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile: http://www.excelforum.com/member.php...o&userid=30364
View this thread: http://www.excelforum.com/showthread...hreadid=504597

Praveen

You might find the excel functions =code and =char useful on this,
and concatenate as you require,

can't think for what purpose you need to know this for though...

or do you refer to shortcut keys?

somethinglikeant

In excel 2002 and later (perhaps xl2000), do Insert=Symbol

in all versions of windows, there is also a character map utilitily in
accessories.

--
Regards,
Tom Ogilvy


"praveen_khm"
wrote in message
...

Hi all,

Is is possible to find the ASCII characters in excel for a perticular
character?

I mean to say that, I need to insert a smiley in excel. I need this :)
and :( in excel. If I need a happy smiley, I can as well use ALT+1. But
if I need a sad one, I am not able to find it. Is there any combination
of characters which can give me that or is there a way to find it.

Thanks in advance,
Praveen


--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile:
http://www.excelforum.com/member.php...o&userid=30364
View this thread: http://www.excelforum.com/showthread...hreadid=504597

Hi,

If you format the cell with the Wingdings font you can use JKL to give
you smileys from happy thru sad.

Cheers
Andy

praveen_khm wrote:
Hi all,

Is is possible to find the ASCII characters in excel for a perticular
character?

I mean to say that, I need to insert a smiley in excel. I need this :)
and :( in excel. If I need a happy smiley, I can as well use ALT+1. But
if I need a sad one, I am not able to find it. Is there any combination
of characters which can give me that or is there a way to find it.

Thanks in advance,
Praveen



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

"Andy Pope" skrev i melding
...

If you format the cell with the Wingdings font you can use JKL to give
you smileys from happy thru sad.

Hi Andy

I use JKLM and even JKLMN in a few apps,these are powerful scales and easy
to make with =CHAR(74 + sum of unwanted points).

Best wishes Harald

Hi Harald,

I think a report with ratings using the M and N smileys would certainly
attract the readers attention!

BTW love your spam email addy :)

Cheers
Andy

Harald Staff wrote:
"Andy Pope" skrev i melding
...


If you format the cell with the Wingdings font you can use JKL to give
you smileys from happy thru sad.


Hi Andy

I use JKLM and even JKLMN in a few apps,these are powerful scales and easy
to make with =CHAR(74 + sum of unwanted points).

Best wishes Harald



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Sorry All,

With all the above suggestions, I could not get the resolution for m
question. I ll let you know the reason. I am creating a test and whe
someone enters a right answer, I need a happy smiley and sad if wrong
For happy smiley, I can as well go to the cell and press ALT+1 whic
gives a happy smiley. Now what do I do for a sad one? Changing th
format of the cell is no meaning as it makes the work cumbersome.

Please help.
Thanks,
Pravee

--
praveen_kh
-----------------------------------------------------------------------
praveen_khm's Profile: http://www.excelforum.com/member.php...fo&userid=3036
View this thread: http://www.excelforum.com/showthread.php?threadid=50459

Enter this formula in to B1 and format the cell with the wingdings font.

=IF(A1=1,"J","L")

If you enter a 1 in cell A1 you should get your smiley face.

Hopefully you can apply this to your test.

Cheers
Andy

praveen_khm wrote:
Sorry All,

With all the above suggestions, I could not get the resolution for my
question. I ll let you know the reason. I am creating a test and when
someone enters a right answer, I need a happy smiley and sad if wrong.
For happy smiley, I can as well go to the cell and press ALT+1 which
gives a happy smiley. Now what do I do for a sad one? Changing the
format of the cell is no meaning as it makes the work cumbersome.

Please help.
Thanks,
Praveen



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info