Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Surekha
 
Posts: n/a
Default How can i convert an ASCII character to decimal/hex in Excel?

Hi,

I would like to convert an ASCII character to Hexadecimal / Decimal in Excel
sheet. Is there any function which can do this for me?

Regards,
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf
 
Posts: n/a
Default How can i convert an ASCII character to decimal/hex in Excel?

I would like to convert an ASCII character to Hexadecimal / Decimal in
Excel sheet. Is there any function which can do this for me?


ASCII to Decimal:
=CODE(A1)

ASCII to Hexadecimal:
=DEC2HEX(CODE(A1))

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
WordPad file convert in Excel Tarique Excel Discussion (Misc queries) 1 April 21st 06 02:48 PM
Convert Excel 4 formula to Excel 2003 format The Gasell Excel Worksheet Functions 3 April 12th 06 05:07 PM
Can I use Excel to convert Chinese character into Unicode? Richard Hsiao Excel Discussion (Misc queries) 0 September 22nd 05 10:06 AM
How can I convert an Excel file to an Adobe .pdf file by using Ex. pammoore2000 Excel Discussion (Misc queries) 5 March 15th 05 03:51 AM
how to convert GETPIVOTDATA from excel 2000 to excel 2002... Need_help_on_excel Excel Worksheet Functions 1 March 15th 05 01:08 AM


All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"