1
00:00:00,080 --> 00:00:04,035
A contact export places a name and an email address together,

2
00:00:04,035 --> 00:00:05,474
separated by a comma.

3
00:00:05,474 --> 00:00:09,788
Keeping them in one column makes filtering and mail-merge preparation awkward.

4
00:00:09,788 --> 00:00:13,744
Google Sheets has a built-in Split text to columns command.

5
00:00:13,744 --> 00:00:17,699
We will use three fictional contacts, protect the neighboring cells from

6
00:00:17,699 --> 00:00:22,373
overwrite, choose the comma separator, and confirm the resulting name-to-email pairs.

7
00:00:22,973 --> 00:00:26,970
The practice CSV contains Avery Stone with avery at example dot

8
00:00:26,970 --> 00:00:30,967
com, Blair Reed with blair at example dot com, and Casey

9
00:00:30,967 --> 00:00:33,510
Chen with casey at example dot com.

10
00:00:33,510 --> 00:00:37,507
Paste the Combined values into column A of a new Sheet.

11
00:00:37,507 --> 00:00:40,050
The comma is the boundary between fields.

12
00:00:40,050 --> 00:00:44,047
First make sure column B is empty because the split result

13
00:00:44,047 --> 00:00:45,864
will occupy the next column.

14
00:00:46,464 --> 00:00:50,503
Select the three combined cells in A two through A four.

15
00:00:50,503 --> 00:00:53,440
Open Data and choose Split text to columns.

16
00:00:53,440 --> 00:00:57,112
Sheets may detect the separator automatically, but for this exercise

17
00:00:57,112 --> 00:01:01,885
choose Comma from the separator menu so the instruction has a verifiable result.

18
00:01:01,885 --> 00:01:05,924
The names should remain in column A and the email addresses

19
00:01:05,924 --> 00:01:07,759
should appear in column B.

20
00:01:07,759 --> 00:01:09,228
Add clear headers afterward.

21
00:01:09,828 --> 00:01:13,129
Read each row across, not only each column down.

22
00:01:13,129 --> 00:01:17,163
Avery Stone must remain next to avery at example dot com;

23
00:01:17,163 --> 00:01:21,198
Blair Reed next to blair at example dot com; Casey Chen

24
00:01:21,198 --> 00:01:23,765
next to casey at example dot com.

25
00:01:23,765 --> 00:01:27,799
If an address is missing or attached to a different name,

26
00:01:27,799 --> 00:01:30,733
undo and inspect the input before trying again.

27
00:01:30,733 --> 00:01:33,667
A successful split preserves the original row relationship.

28
00:01:34,267 --> 00:01:38,632
If Sheets leaves the entire text in one cell, it probably

29
00:01:38,632 --> 00:01:41,409
did not choose the comma you intended.

30
00:01:41,409 --> 00:01:44,583
Open the separator control and set Comma explicitly.

31
00:01:44,583 --> 00:01:48,948
If the source uses semicolons, tabs, or a custom character, select

32
00:01:48,948 --> 00:01:53,709
the matching separator instead; do not blindly follow a comma-based recipe.

33
00:01:53,709 --> 00:01:58,471
Check a row containing the most punctuation before processing a larger export.

34
00:01:59,071 --> 00:02:02,537
The split needs room in the cells to the right.

35
00:02:02,537 --> 00:02:06,351
If column B already contains notes, move those notes or insert

36
00:02:06,351 --> 00:02:10,858
a blank column before splitting, then compare the result to your source copy.

37
00:02:10,858 --> 00:02:13,631
Splitting the wrong selection can damage unrelated data.

38
00:02:13,631 --> 00:02:17,444
The safe practice is to work in a duplicate Sheet and

39
00:02:17,444 --> 00:02:20,565
verify the name and email in every fictional row.

40
00:02:21,165 --> 00:02:26,157
The answer file records the expected two-column output for all three contacts.

41
00:02:26,157 --> 00:02:30,381
When your Sheet matches those pairs, label the columns Name and

42
00:02:30,381 --> 00:02:34,605
Email and retain the source CSV until the check is complete.

43
00:02:34,605 --> 00:02:38,445
This lesson demonstrates a clearly defined comma delimiter; real exports

44
00:02:38,445 --> 00:02:42,669
with embedded commas inside quoted fields may need a proper CSV

45
00:02:42,669 --> 00:02:45,357
import rather than this simple split command.