MID Function in Excel

The MID function returns the character from the middle of a text string where a staring position and length are mentioned. If you ever need to display some characters from a string, then the MID function is best for you. It is one of the popular functions of excel and widely used in a complex formula.

Syntax of the MID function is

MID(text,Start_num,num_chars)

Text: The text from where you want to extract characters.

Start_Num: It is also called the starting position. For example, If you want to extract "soft" from the string "Microsoft", here start_num will be 6. #VALUE error will come if this argument is zero.

Num_chars: This argument shows how long our result will be. In the above example, the num_chars is 4.

In the above example, you easily find that if the start_num and num_chars are zero the MID function gives a blank result.

Char Function in Excel

The Char function returns the character specified by the code number from the character set for your computer. The character set varies from the operating system to the operating system. The main purpose of char function is that get a character from the number.


Syntax of the Char function is

=CHAR(number)

In the example given above, you can see that every number (A number range from 1 to 255 )has been converted into a character with the help of char function. When we want to convert a number more than 255 its gives an #VALUE error.

Numbervalue function in Excel

Numbervalue is a function that converts a string into a number in a Locale-independent way.


Syntax of the Numbervalue function is

=Numbervalue(Text,[decimal_separator],[group_separator])

Arguments

Text: The string that you want to convert.

Decimal_Separator: It is optional. The character that separates the integer and decimal part from the number.

Group_Separator: It is optional. The character that separates the group from the number.

            

Value Function in Excel

The value function is a function that converts a text that represents a number to number. The value function will change the same text that has a numeric value in the cell.


Syntax of the Value Function

=VALUE(Text)

Here text arguments must be Number, Date, and Time format.

When you try to convert a non-numeric text it gives a #VALUE error.

Text Function in Excel

The Excel TEXT function is a function that converts a value to text in a specified format.

Syntax of the Text function is

=TEXT(value,format_text)

A number format is a special code to display the value in the desired format. It changes only its display without changing the original data. This is very useful for automating formatting.

There are many Build-in formats present in excel. I have used some build-in formats, you can use any of the formats.

Fixed Function in Excel

Fixed Function in excel is a function that rounds a number to the specified numbers of decimals and returns as text with or without commas.

Syntax of the Fixed function is

=FIXED(Number,[decimals],[no_commas])

Arguments

Number: The number you want to round, you can provide the number directly or reference of number.

Decimals: It is optional, After decimal how many digits you want to round the number, you can mentions here. By default, it is 2.

No_commas: True for preventing commas and False for not preventing commas. By default, it gives the result with commas.