Fortune Telling Collection - Horoscope - Excuse me, how to set the excel function formula so that the above table = the first 4 words of the following table?

Excuse me, how to set the excel function formula so that the above table = the first 4 words of the following table?

There are many methods, the following two are commonly used;

1, function left? Indicates that a specified number of characters are returned from the first character of the text string;

Grammar: (text, numeric characters)

Text means to extract conceited strings, such as "Nanhai Guicheng Juxing Computer Room" or cell reference "b1";

Num_chars indicates the number of characters to be extracted, or 1 if omitted.

2. function MID? Indicates that a character of a specified length is returned from a specified starting position in a text string;

Syntax: (text, number of starting characters, number of characters)

Same text as above

Start_num indicates the position of the first character to be extracted. Words? The first character in is 1.

Num_chars specifies the length of the characters to be extracted.

Please look at the picture example.