1
00:00:00,080 --> 00:00:03,851
A contact export stores Rivera, Maya in one cell, but you

2
00:00:03,851 --> 00:00:06,593
need family and given names in separate columns.

3
00:00:06,593 --> 00:00:10,364
Excel for the web does not use the desktop Text to

4
00:00:10,364 --> 00:00:12,078
Columns wizard for this task.

5
00:00:12,078 --> 00:00:16,192
We will use TEXTSPLIT with the exact comma-and-space delimiter, then

6
00:00:16,192 --> 00:00:17,906
check all three fictional names.

7
00:00:17,906 --> 00:00:22,362
The output cells must be empty so the result can spread across columns.

8
00:00:22,962 --> 00:00:26,806
Paste the three names from the practice CSV into column A,

9
00:00:26,806 --> 00:00:29,952
beginning at A two under the Full name header.

10
00:00:29,952 --> 00:00:33,447
The rows are Rivera, Maya; Brooks, Eli; and Chen, Nora.

11
00:00:33,447 --> 00:00:37,641
Put Family name in B one and Given name in C one.

12
00:00:37,641 --> 00:00:41,485
Make sure B two through C four are blank before entering

13
00:00:41,485 --> 00:00:44,281
a formula, since TEXTSPLIT returns multiple adjacent cells.

14
00:00:44,881 --> 00:00:49,528
In B two, enter equals TEXTSPLIT, open parenthesis, A two, comma,

15
00:00:49,528 --> 00:00:52,908
the quoted comma and space, then close parenthesis.

16
00:00:52,908 --> 00:00:57,555
In standard English Excel notation the formula is equals TEXTSPLIT open

17
00:00:57,555 --> 00:01:01,779
parenthesis A two comma quote comma space quote close parenthesis.

18
00:01:01,779 --> 00:01:06,426
The second argument is the column delimiter, so one input cell

19
00:01:06,426 --> 00:01:08,539
returns two neighboring output cells.

20
00:01:09,139 --> 00:01:13,811
After pressing Enter, B two should show Rivera and C two should show Maya.

21
00:01:13,811 --> 00:01:16,814
Compare both pieces to the original in A two.

22
00:01:16,814 --> 00:01:20,485
If you see a spill error, clear the intended output cells;

23
00:01:20,485 --> 00:01:22,821
do not delete the original source value.

24
00:01:22,821 --> 00:01:26,492
If you get one unsplit value, inspect the separator in A

25
00:01:26,492 --> 00:01:30,163
two because a different punctuation mark will not match the delimiter.

26
00:01:30,763 --> 00:01:34,575
Copy the formula in B two down to B three and

27
00:01:34,575 --> 00:01:37,347
B four, leaving the corresponding C cells free.

28
00:01:37,347 --> 00:01:40,812
Confirm Brooks pairs with Eli and Chen pairs with Nora.

29
00:01:40,812 --> 00:01:44,623
Do not sort just one output column after splitting: that could

30
00:01:44,623 --> 00:01:47,742
separate family and given names from the original row.

31
00:01:47,742 --> 00:01:52,246
Keep column A as a reference until you have checked all converted records.

32
00:01:52,846 --> 00:01:55,382
TEXTSPLIT accepts both column and row delimiters.

33
00:01:55,382 --> 00:02:00,093
If the comma-and-space string is supplied as the third argument instead

34
00:02:00,093 --> 00:02:04,441
of the second, results may flow down rows rather than across columns.

35
00:02:04,441 --> 00:02:08,426
For this contact task, the separator belongs in the second argument.

36
00:02:08,426 --> 00:02:12,774
Also note that a comma-only separator may leave a leading space

37
00:02:12,774 --> 00:02:14,586
before Maya, Eli, or Nora.

38
00:02:15,186 --> 00:02:20,150
The answer file lists all six output pieces for the three fictional contacts.

39
00:02:20,150 --> 00:02:24,350
The exercise is complete when each full name still corresponds to

40
00:02:24,350 --> 00:02:28,550
its two parts and the original column remains available for comparison.

41
00:02:28,550 --> 00:02:32,750
On real data, examine outliers such as names with more than

42
00:02:32,750 --> 00:02:36,568
one comma or missing spaces before filling thousands of rows.

43
00:02:36,568 --> 00:02:40,386
This simple delimiter example does not solve every name format.