Saturday, April 19, 2014

Excel - MID Function - Mengeluarkan Huruf Terpilih Dalam Cell Excel

DESCRIPTION

The Microsoft Excel MID function extracts a substring from a string (starting at any position).

SYNTAX

The syntax for the Microsoft Excel MID function is:
MID( text, start_position, number_of_characters )

PARAMETERS OR ARGUMENTS

text is the string that you wish to extract from.
start_position indicates the position in the string that you will begin extracting from. The first position in the string is 1.
number_of_characters indicates the number of characters that you wish to extract.
Extract a Substring in Excel

No comments: