Prompt: How to split column A to be two columns; one column contains the Chinese first name; the other column contains the remaining Chinese name?
to Excel inside AI Copilot
To split column A into two columns, where one column contains the Chinese first name and the other column contains the remaining Chinese name, you can use the following steps:
- Insert two new columns next to column A. Let’s assume these new columns are B and C.
- Use the following formulas to split the names:
- In cell B2 (for the first name):
=LEFT(A2, 1) - In cell C2 (for the remaining name):
=MID(A2, 2, LEN(A2) – 1)
- In cell B2 (for the first name):
- Copy the formulas down the columns to apply them to all rows.
This will split the names in column A into two columns, with the first name in column B and the remaining name in column C.
Prompt: How to list the distinct "Family name” (column B) into column E.
to Excel inside AI Copilot
Count the Distinct Family Name:
