1 00:00:00,799 --> 00:00:02,310 in this video we're going to show you 2 00:00:02,310 --> 00:00:02,320 in this video we're going to show you 3 00:00:02,320 --> 00:00:04,630 in this video we're going to show you how to split cells in microsoft excel 4 00:00:04,630 --> 00:00:04,640 how to split cells in microsoft excel 5 00:00:04,640 --> 00:00:07,590 how to split cells in microsoft excel into columns using delimiters or a fixed 6 00:00:07,590 --> 00:00:07,600 into columns using delimiters or a fixed 7 00:00:07,600 --> 00:00:09,110 into columns using delimiters or a fixed width method 8 00:00:09,110 --> 00:00:09,120 width method 9 00:00:09,120 --> 00:00:11,190 width method use the clickable sections below to skip 10 00:00:11,190 --> 00:00:11,200 use the clickable sections below to skip 11 00:00:11,200 --> 00:00:13,990 use the clickable sections below to skip to each method 12 00:00:13,990 --> 00:00:14,000 13 00:00:14,000 --> 00:00:15,829 to use this method you'll need to make 14 00:00:15,829 --> 00:00:15,839 to use this method you'll need to make 15 00:00:15,839 --> 00:00:17,670 to use this method you'll need to make sure that all the data in your cells 16 00:00:17,670 --> 00:00:17,680 sure that all the data in your cells 17 00:00:17,680 --> 00:00:18,950 sure that all the data in your cells that you want to isolate 18 00:00:18,950 --> 00:00:18,960 that you want to isolate 19 00:00:18,960 --> 00:00:21,510 that you want to isolate are separated by a delimiter this can be 20 00:00:21,510 --> 00:00:21,520 are separated by a delimiter this can be 21 00:00:21,520 --> 00:00:22,710 are separated by a delimiter this can be a comma 22 00:00:22,710 --> 00:00:22,720 a comma 23 00:00:22,720 --> 00:00:26,790 a comma period dash or a space 24 00:00:26,790 --> 00:00:26,800 period dash or a space 25 00:00:26,800 --> 00:00:28,550 period dash or a space we're separating a list of names on a 26 00:00:28,550 --> 00:00:28,560 we're separating a list of names on a 27 00:00:28,560 --> 00:00:30,470 we're separating a list of names on a guest list using commas 28 00:00:30,470 --> 00:00:30,480 guest list using commas 29 00:00:30,480 --> 00:00:33,510 guest list using commas to separate first and last names 30 00:00:33,510 --> 00:00:33,520 to separate first and last names 31 00:00:33,520 --> 00:00:35,750 to separate first and last names first click and drag to select the cells 32 00:00:35,750 --> 00:00:35,760 first click and drag to select the cells 33 00:00:35,760 --> 00:00:37,190 first click and drag to select the cells you want to split 34 00:00:37,190 --> 00:00:37,200 you want to split 35 00:00:37,200 --> 00:00:39,350 you want to split click on the data tab at the top and 36 00:00:39,350 --> 00:00:39,360 click on the data tab at the top and 37 00:00:39,360 --> 00:00:41,110 click on the data tab at the top and then text to columns 38 00:00:41,110 --> 00:00:41,120 then text to columns 39 00:00:41,120 --> 00:00:43,670 then text to columns a pop-up window will appear from the two 40 00:00:43,670 --> 00:00:43,680 a pop-up window will appear from the two 41 00:00:43,680 --> 00:00:44,470 a pop-up window will appear from the two options 42 00:00:44,470 --> 00:00:44,480 options 43 00:00:44,480 --> 00:00:47,590 options choose delimited and then click next 44 00:00:47,590 --> 00:00:47,600 choose delimited and then click next 45 00:00:47,600 --> 00:00:49,270 choose delimited and then click next click the check marks next to each 46 00:00:49,270 --> 00:00:49,280 click the check marks next to each 47 00:00:49,280 --> 00:00:51,510 click the check marks next to each delimiter that excel should use 48 00:00:51,510 --> 00:00:51,520 delimiter that excel should use 49 00:00:51,520 --> 00:00:53,510 delimiter that excel should use to know when to separate the information 50 00:00:53,510 --> 00:00:53,520 to know when to separate the information 51 00:00:53,520 --> 00:00:55,110 to know when to separate the information in the cells 52 00:00:55,110 --> 00:00:55,120 in the cells 53 00:00:55,120 --> 00:00:58,310 in the cells in this case we'll just click on comma 54 00:00:58,310 --> 00:00:58,320 in this case we'll just click on comma 55 00:00:58,320 --> 00:01:00,389 in this case we'll just click on comma make sure this check mark is used in 56 00:01:00,389 --> 00:01:00,399 make sure this check mark is used in 57 00:01:00,399 --> 00:01:02,389 make sure this check mark is used in case two delimiters are listed one after 58 00:01:02,389 --> 00:01:02,399 case two delimiters are listed one after 59 00:01:02,399 --> 00:01:03,750 case two delimiters are listed one after another in the cells 60 00:01:03,750 --> 00:01:03,760 another in the cells 61 00:01:03,760 --> 00:01:06,070 another in the cells in this case we have a comma followed by 62 00:01:06,070 --> 00:01:06,080 in this case we have a comma followed by 63 00:01:06,080 --> 00:01:07,590 in this case we have a comma followed by a space 64 00:01:07,590 --> 00:01:07,600 a space 65 00:01:07,600 --> 00:01:10,390 a space click next to continue select if your 66 00:01:10,390 --> 00:01:10,400 click next to continue select if your 67 00:01:10,400 --> 00:01:11,510 click next to continue select if your data is text 68 00:01:11,510 --> 00:01:11,520 data is text 69 00:01:11,520 --> 00:01:13,910 data is text a date or anything else by clicking 70 00:01:13,910 --> 00:01:13,920 a date or anything else by clicking 71 00:01:13,920 --> 00:01:15,429 a date or anything else by clicking general here 72 00:01:15,429 --> 00:01:15,439 general here 73 00:01:15,439 --> 00:01:16,630 general here now you can choose where in the 74 00:01:16,630 --> 00:01:16,640 now you can choose where in the 75 00:01:16,640 --> 00:01:19,270 now you can choose where in the spreadsheet you want your data to appear 76 00:01:19,270 --> 00:01:19,280 spreadsheet you want your data to appear 77 00:01:19,280 --> 00:01:21,190 spreadsheet you want your data to appear type in the number of the top left cell 78 00:01:21,190 --> 00:01:21,200 type in the number of the top left cell 79 00:01:21,200 --> 00:01:23,510 type in the number of the top left cell where you want your data to start here 80 00:01:23,510 --> 00:01:23,520 where you want your data to start here 81 00:01:23,520 --> 00:01:25,350 where you want your data to start here leave it blank to overwrite your 82 00:01:25,350 --> 00:01:25,360 leave it blank to overwrite your 83 00:01:25,360 --> 00:01:27,350 leave it blank to overwrite your existing cells 84 00:01:27,350 --> 00:01:27,360 existing cells 85 00:01:27,360 --> 00:01:31,270 existing cells click finish to complete 86 00:01:31,270 --> 00:01:31,280 87 00:01:31,280 --> 00:01:33,429 using the fixed width method you can 88 00:01:33,429 --> 00:01:33,439 using the fixed width method you can 89 00:01:33,439 --> 00:01:34,710 using the fixed width method you can separate information 90 00:01:34,710 --> 00:01:34,720 separate information 91 00:01:34,720 --> 00:01:37,510 separate information based on their position in the cells 92 00:01:37,510 --> 00:01:37,520 based on their position in the cells 93 00:01:37,520 --> 00:01:38,310 based on their position in the cells first 94 00:01:38,310 --> 00:01:38,320 first 95 00:01:38,320 --> 00:01:39,749 first highlight the cells with all the 96 00:01:39,749 --> 00:01:39,759 highlight the cells with all the 97 00:01:39,759 --> 00:01:41,990 highlight the cells with all the information that you want to split 98 00:01:41,990 --> 00:01:42,000 information that you want to split 99 00:01:42,000 --> 00:01:44,149 information that you want to split go to the data tab at the top and then 100 00:01:44,149 --> 00:01:44,159 go to the data tab at the top and then 101 00:01:44,159 --> 00:01:46,149 go to the data tab at the top and then click on text to columns 102 00:01:46,149 --> 00:01:46,159 click on text to columns 103 00:01:46,159 --> 00:01:49,109 click on text to columns a pop-up window will appear choose the 104 00:01:49,109 --> 00:01:49,119 a pop-up window will appear choose the 105 00:01:49,119 --> 00:01:49,590 a pop-up window will appear choose the option 106 00:01:49,590 --> 00:01:49,600 option 107 00:01:49,600 --> 00:01:52,789 option fixed width here and then click on next 108 00:01:52,789 --> 00:01:52,799 fixed width here and then click on next 109 00:01:52,799 --> 00:01:54,550 fixed width here and then click on next all the data you've selected will show 110 00:01:54,550 --> 00:01:54,560 all the data you've selected will show 111 00:01:54,560 --> 00:01:56,550 all the data you've selected will show in your data preview here 112 00:01:56,550 --> 00:01:56,560 in your data preview here 113 00:01:56,560 --> 00:01:58,709 in your data preview here click somewhere on the data preview to 114 00:01:58,709 --> 00:01:58,719 click somewhere on the data preview to 115 00:01:58,719 --> 00:02:00,630 click somewhere on the data preview to create a break line 116 00:02:00,630 --> 00:02:00,640 create a break line 117 00:02:00,640 --> 00:02:02,870 create a break line click and drag this line to a position 118 00:02:02,870 --> 00:02:02,880 click and drag this line to a position 119 00:02:02,880 --> 00:02:04,389 click and drag this line to a position where you want to split 120 00:02:04,389 --> 00:02:04,399 where you want to split 121 00:02:04,399 --> 00:02:06,149 where you want to split you can add multiple break lines to 122 00:02:06,149 --> 00:02:06,159 you can add multiple break lines to 123 00:02:06,159 --> 00:02:07,749 you can add multiple break lines to split the cell into more than two 124 00:02:07,749 --> 00:02:07,759 split the cell into more than two 125 00:02:07,759 --> 00:02:08,710 split the cell into more than two columns 126 00:02:08,710 --> 00:02:08,720 columns 127 00:02:08,720 --> 00:02:10,869 columns to delete a break line double click on 128 00:02:10,869 --> 00:02:10,879 to delete a break line double click on 129 00:02:10,879 --> 00:02:11,830 to delete a break line double click on it 130 00:02:11,830 --> 00:02:11,840 it 131 00:02:11,840 --> 00:02:14,390 it click next to continue complete your 132 00:02:14,390 --> 00:02:14,400 click next to continue complete your 133 00:02:14,400 --> 00:02:15,990 click next to continue complete your formatting and choose where you want the 134 00:02:15,990 --> 00:02:16,000 formatting and choose where you want the 135 00:02:16,000 --> 00:02:17,670 formatting and choose where you want the new information on your spreadsheet 136 00:02:17,670 --> 00:02:17,680 new information on your spreadsheet 137 00:02:17,680 --> 00:02:19,510 new information on your spreadsheet by adding the new top left cell number 138 00:02:19,510 --> 00:02:19,520 by adding the new top left cell number 139 00:02:19,520 --> 00:02:20,370 by adding the new top left cell number here 140 00:02:20,370 --> 00:02:20,380 here 141 00:02:20,380 --> 00:02:21,589 here [Music] 142 00:02:21,589 --> 00:02:21,599 [Music] 143 00:02:21,599 --> 00:02:23,430 [Music] if you want the new columns to overwrite 144 00:02:23,430 --> 00:02:23,440 if you want the new columns to overwrite 145 00:02:23,440 --> 00:02:26,150 if you want the new columns to overwrite your data just leave this empty 146 00:02:26,150 --> 00:02:26,160 your data just leave this empty 147 00:02:26,160 --> 00:02:36,800 your data just leave this empty click finish to complete