Extract the email user name, the formula is: =LEFT(A1, FIND("@", A1)-1).
Formula analysis: Use the find function to find the position of the @ character, and then use the left function to get the number of characters to the left of the @ character. The reason why it is reduced by 1 is because the @ character itself occupies a position.