Excel from the rookie to become a master of the Left function

  Fifth move: stay head to tail (Left function)

 This trick is used to intercept the raw data. Interception approach is a character from the beginning, the interception of the contents of a user-specified length.

 For example: In a work table, a column address information is recorded with provincial, city, street and so on. If you want to insert more than one, adding provinces in the data for selected provinces, it can intercept the function automatically, without manual input.

 Syntax

 LEFT (text, num_chars)

 Text is included to extract the text string of characters, you can directly enter the cell containing the target name of the text.

 Num_chars up to the LEFT of the specified number of characters extracted.

 Num_chars must be greater than or equal to 0.

 If num_chars greater than the length of the text, then LEFT returns all of the text.

 If you omit num_chars, is assumed to be 1.

 Application example: the data containing different places, the use of "Left" function is very simple separation from their provinces.

 Explained

 The formula "= Left (A2, 3)", said to be intercepted in the A2 data contents of the cell A2 ", Dongcheng District, Dongguan City, Guangdong Province, ... ", "3"indicates the beginning from the first of the interception of three characters, so The system returns "Guangdong province. "