PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

EXCEL FUNCTIONS-CHAR

INTRODUCTION

CHAR function comes under the TEXT category in Excel.

CHAR function returns the character specified by an ANSI CHARACTER from 1 to 255.

ANSI, while the development of computing system defined the characters such as a to z, A TO Z, !,@ and so many other symbols with the ANSI CODE ranging from 1 to 255.

This function is specifically used if we need to convert the character set from one system to other or we can use if we need to use any character. 

PURPOSE OF CHAR IN EXCEL

CHAR FUNCTION returns the character specified by a number.(ANSI CODE)(1-255)

PREREQUISITES TO LEARN CHAR

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

 

  •  Basic understanding of how to use a formula or function.
  •  Basic understanding of rows and columns in Excel.
  • Some information about the financial terms is an advantage for the use of such formulas.
  •  Of course, Excel software.
Helpful links for the prerequisites mentioned above

SYNTAX: CHAR

The Syntax for the function is

=CHAR(NUMBER)

NUMBER is any number CORRESPONDING TO A CHARACTER.(1 TO 255)

 

EXAMPLE:CHAR IN EXCEL

DATA SAMPLE

Let us check the different codes from 1 to 255.

FUNCTION CHAR EXAMPLE EXCEL
EXCEL:CHAR FUNCTION ANIMATED EXAMLPE

STEPS TO USE CHAR

The data has been put from the numbers 1 to 255.
The function has been used in the next cell corresponding to the number.
 
=Char(number).
All the numbers from 1 to 255 has been used.
Some character which are not supported in the current system are shown as a small square.All other are shown properly.

KNOWLEDGE BYTES

WHAT ARE ANSI CHARACTERS

ANSI STANDS FOR American National Standards Institute.
When computing was developing, different methods were used to define some special characters.
As we all know that basic language in any electronics is binary i.e. 0 and 1. Different characters were attached to certain number system like ASCII which defined the character in a system from 1 to 127.
So after this came the ANSI which included ASCII and extended it to 255 and added more character in the set.

 

OTHER WAYS TO REACH THIS ARTICLE

  • CHAR FUNCTION, CONVERT NUMBER TO SYMBOL,INSERT SYMBOL DIRECTLY, ANSI CHARACTER INSERTION

YOU MAY LIKE

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: