| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
character to integer conversion
Is there any way to convert a charatcer into its decimal value in excel VBA? E.g. to compare "A" to the number 65 which is its decimal equivalent? Thank you! -- lithium81 ------------------------------------------------------------------------ lithium81's Profile: http://www.excelforum.com/member.php...o&userid=29461 View this thread: http://www.excelforum.com/showthread...hreadid=520458 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
character to integer conversion
Hi Lithium81,
MsgBox Asc("A") --- Regards, Norman "lithium81" wrote in message ... Is there any way to convert a charatcer into its decimal value in excel VBA? E.g. to compare "A" to the number 65 which is its decimal equivalent? Thank you! -- lithium81 ------------------------------------------------------------------------ lithium81's Profile: http://www.excelforum.com/member.php...o&userid=29461 View this thread: http://www.excelforum.com/showthread...hreadid=520458 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
character to integer conversion
A1="A"
in B1 put =Code(A1) or =Code("A") "lithium81" wrote: Is there any way to convert a charatcer into its decimal value in excel VBA? E.g. to compare "A" to the number 65 which is its decimal equivalent? Thank you! -- lithium81 ------------------------------------------------------------------------ lithium81's Profile: http://www.excelforum.com/member.php...o&userid=29461 View this thread: http://www.excelforum.com/showthread...hreadid=520458 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
character to integer conversion
lithium81,
If on a worksheet, check the CODE and CHAR functions in Excel Help If in VBA, then it's ASC and CHR in VBA help. NickHK "lithium81" wrote in message ... Is there any way to convert a charatcer into its decimal value in excel VBA? E.g. to compare "A" to the number 65 which is its decimal equivalent? Thank you! -- lithium81 ------------------------------------------------------------------------ lithium81's Profile: http://www.excelforum.com/member.php...o&userid=29461 View this thread: http://www.excelforum.com/showthread...hreadid=520458 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
character to integer conversion
Thanks folks! That helps a lot!! -- lithium81 ------------------------------------------------------------------------ lithium81's Profile: http://www.excelforum.com/member.php...o&userid=29461 View this thread: http://www.excelforum.com/showthread...hreadid=520458 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
| How do I add an integer to an existing integer? | Excel Worksheet Functions | |||
| Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
| Stopping conversion to an elipse character | Excel Discussion (Misc queries) | |||
| importing undelimited text file data, character-by-character | Excel Programming | |||
![lithium81[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
