• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

CHAR Function

Hi Shay,

Its use completely depends on the scenario..however, below are some of the useful links

With that said, the basic use of the Function remains unchanged but yes it depends on a user when, where and how to use it.

http://www.excelitems.com/2012/07/char-function-excel-chr-vba-ascii-code.html

http://www.cpearson.com/excel/chars.htm

https://support.office.com/en-us/article/Remove-spaces-and-nonprinting-characters-from-text-023f3a08-3d56-49e4-bf0c-fe5303222c9d

In case, you are asking this question in reference to some particular issue or problem then you may even consider shooting it here..
 
Hello again, what do I need to change in the Excel file attached in order have the CHAR function returning exactly what it should according to the ascii? (See the PDF file). For example, look at the six last rows and see t he mismatch.

TY
 

Attachments

Hi ,

I am not sure , but I doubt that it can be done.

The ASCII characters shown in the .xlsx file are the ASCII codes as recognized by the international standard on these , which are governed by the International Standards Organization , through their standard 8859 :

https://en.wikipedia.org/wiki/ISO/IEC_8859

The ASCII characters shown in the .pdf file are the ASCII codes under MS-DOS , now termed as code page 437 :

https://en.wikipedia.org/wiki/Code_page_437

The equivalence of these two different character sets is shown here :

http://www.kostis.net/charsets/cp437.htm

How to switch between these two is the question ; hope someone else can answer this.

Narayan
 
Hi ,

Insert Symbol will do what it says , but this is different from what the CHAR function does ; to go back to your initial post , the CHAR function will return what it does ; I don't think you can do anything to change this.

Narayan
 
If you check CHAR function help then it specifies for windows OS, it will return ANSI code page. It does not provide "transcoding option" as argument to adjust it to suitable character set.

Help further specifies that the Character Set specified by your computer. So the code returned will be dependent on Regional Settings on your computer. Not recommended to alter.

So short answer will be "No".
 
You must log in or register to reply here.
Back
Top