As you see, the formulas are far from obvious, so you may want to download the sample Excel Split Cells workbook to examine them closer.. The feature also includes an easy-to-use wizard, which is why most people prefer using it. In the Column data format area, select . 2. Split cells In the table, click the cell that you want to split. After that select the View tab > point the cursor to the Window group > select Split.So now your worksheet in Microsoft Excel is divided into 4 proportional panels. Split Cells In Excel 2010 To split the contents of a cell into multiple cells, use the Text to Columns wizard.For example, let's split full names into last and first names. Step 3: Click the Data tab at the top of the . [/text_output] [text_output] Set the number of rows ( Row) and column ( Column) that you want to make from the cells you have selected. Excel-VBA Now Value: Split Second. tom1977. It also handles any text format, whether the separating text is a space, a tab, or a . Answer (1 of 3): Okay, a bit ambiguous. How to split info in one cell into multiple rows - Quora Hi. Select the cells that you want to merge. 2. from the main menu ribbon, click on the Data tab. This will select and open the Format menu. However, for Non-Standard patterns such as Capital letters . One of the most common methods to split a cell in Excel is using the Text to Columns tool. Split cells. How to Split Cells in Excel | Spreadsheets Made Easy Step 2: Click the button at the top-left corner of your spreadsheet (the cell between the 1 and the A) to select the entire worksheet. Can you split a cell in Excel 2010 the way a cell is split ... Some of the processes are Unmerge cells, Flash Fill, and Text to Column feature. How to Split Data Into Multiple Columns in Excel Split words in a cell range into a cell each [UDF] 0. Open your Excel and open the database in which the Columns has to be separated. Step 13: Select white as the fill color under the "Fill color" group box. Now, click the Data tab on your spreadsheet. Excel does not allow it a priori in a cell, but (one solution among others…) in this way you can use the right-triangle object to split a cell half in Excel. Or, click the drop-down arrow next to the Merge & Center button and select Unmerge Cells. Or press key CTRL +C for copying the data. Step 1: Open the spreadsheet containing the column of data that you watn to split. In excel, there are many ways to split cells. Select the cells containing the text. Is there a way to do the same thing in Excel 2010. In the Merge group, click Split Cells. 3. In Excel, you can also split an unmerged cell using the Text to Columns option. Select the cells you want to split into two cells. Open the Excel spreadsheet containing the data you want to split, then: Highlight the column that contains the combined data (e.g., Last Name, First Name) by clicking the letter directly above the column. Continue reading to learn how to split single column data into multiple columns in Excel 2010. Do you mean split it into multiple rows in the same cell? Select the column of full names that you'd like to separate. The first step, you need to open Microsoft Excel first. If you have data in the next cell, select the cell and right click on it. If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. It easily works in windows 2010. For Instance: We need to split the Name column. Cells can also be broken up into several smaller cells by using the Split Cells command. Split Cells. Step 2: Adjusting the Split Custom Answer: Select the text that you wish to strikethrough. Drag the fill handle till the end of the data range. For example, take c:\users\jon\stuff.txt and make it into two separate cells, one containing C:\users\jon\ and the other cell containing stuff.txt I have managed to extract the file names using this formula, but my Excel 'skills' are lacking the correct commands/syntax to do the same thing with the remainder of the path. In Microsoft Excel 2010 and above, the Merged cell feature is under the Home tab and is shown in the picture below. Select the cells to be merged and press Alt + Enter key. Click the "Text to Columns" button in the Data Tools section. Get instant live expert help on I need help with split cells in excel 2010 "My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!" . Click the Merge cells button in the formatting bar. In this article, we will see the different processes on how to split cells in excel. Select the cells you want to split into cells. The Data preview section shows you what your content would look like. A Wizard will pop-up and help you split cells in Excel: In this wizard, you will be guided on how to split up your cells into multiple ones. To do this, You will find it in the Insert tab > Illustrations group of commands > click on the Shapes drop-down arrow > select Right triangle shape from the Basic shapes group. Delimited works great in our example, as the names are separated by commas. In step 1 of " convert to Text Columns wizard ", choose " Delimited " to specify the delimiter that should be used, to split the contents of the cells. Launch Excel 2010, Open datasheet, choose the column you want to split, right-click the column next to it, and on its context menu click Insert. When cells with multiple values are merged, the upper-left most cell will be the data of the merged cell. Step 2: Click the column heading at the top of the spreadsheet so that the column with the data to be split is highlighted. Then Hit "O". Step 12: Click on the "Format Shape" option. If you wish to separate data from one column into two follow the instructions below: 1. Click Data > From Sheet.If the data is not in an Excel Table, Excel converts it into an Excel Table first. MS WORD: Alt+A and release key "A" then press "M" cell will be merged in Ms Word. Step 4: And here is the result after successfully splitting the cell: As you can see, cell STT from 1 cell has been split into 2 cells after performing Steps 1 to 3 above. How do I split a cell in half horizontally in Excel 2010? Step 2 . Under the Data Tools tab, select the 'Text to Columns' option to display the 'Convert Text to Columns Wizard - Step 1 to 3' dialog box. This will start a new row in the cell you are currently in. This will select and open the Home tab in the ribbon. However, when I am charting, I don't want to list everything in 15 minute increments. Splitting cells also provide better sorting and filtering of an existing table. Why *I* need to split single cells is a fairly simple reason. On the Data tab, click the Text to Columns option. Refer below screenshot. Enter the number of rows and columns you want the cell split into. Examples of Split Cell in Excel. While your mouse is over the selected text, right-click and then select "Format Cells" from the popup menu. In the Merge group, click Split Cells. Click for full-featured 30 days free trial! Click Next.. You can also right-click a cell and select Split Cells from the menu. On the Data tab, in the Data Tools group, click Text to Columns.The Convert Text to Columns Wizard opens.. You just need to do the following steps: #1 select the range of cells that you want to split. Next, to be able to set a proportional split area, you click cell A1. To select multiple non-adjacent rows or columns, keep pressing the "Ctrl" key while clicking on each one of them. Excel 2007. Below is an example of the button in each of the versions of Excel and Calc. This can either be the entire cell or only a character in the cell. Click the Layout tab. Open the Fill tab in the Format Cells dialog box. This feature works the same in all modern versions of Microsoft Excel: 2010, 2013, and 2016. Click OK when you're done. Under Table Tools, on the Layout tab, in the Merge group, click Split Cells. Posts. Click the Layout tab. Next Select Text to Columns and proceed according to the instructions.. Split a Cell. Select a cell. Fill Effects dialog box will appear. Select the merged cell. Next, to be able to set a proportional split area, you click cell A1. The selected Cell will become the top-left corner Cell of the bottom-right pane, after Excel split the worksheet window into four Split Panes. For the Delimited option, select the character you want to use for splitting the data. Step 3: In the Convert Text to Columns Wizard, if you want to split the text into the cells based on a comma, space, or other characters, select the . In an open Excel workbook, click and select all the cells you want to split. Enter the number of columns or rows that you want to split the selected . Step 10: Drag and resize the shape to split the yellow-filled cell diagonally. Now, Excel will recognize the pattern and will fill the remaining cells for you. The first step, you need to open Microsoft Excel first. In Excel, you can also split an unmerged cell using the Text to Columns option. Hot Network Questions Step 2: Adjusting the Split Custom In the Fill Effects dialog box, choose a color for Color 1 open and choose another color for Color 2 option. Split a cell - support.microsoft.com. Click on the Copy option under the Clipboard section. Here's what you do: Select one or more cells you want to unmerge. You cannot unmerge a cell which has not yet been merged with one or more . In the Convert Text to Columns Wizard, select "Delimited" and then click "Next.". Fill Effects dialog box will appear. In excel, we can split the cells into multiple columns by using the TEXT TO COLUMN tool. Click on Data in the ribbon and then go ahead and select Text to . Click on the Fill Effects… command. How to split cells in Excel 2016 / 365 / 2019 spreadsheets Horizontal split cells in Excel rows. Click the "Data" tab at the top of the Excel Ribbon. In the Split Cells dialog, select the number of columns and rows that you want and then click OK. The easiest way on how to split Cells in Excel or split Columns in Excel, is to select the column you want to split. Question: How do I draw a line through a value in a cell in Microsoft Excel 2010? ; Select the approach that fits your data layout. It still fits into the space it was in before. In this example, Cell address C351 is selected as shown in below image. Step 1 - Select the Cell where you want to split the Excel worksheet window to four panes horizontally and vertically. Select the range with full names. Unlike when working with tables in Microsoft Word, PowerPoint and Outlook; there is no straightforward Split command for achieving horizontal splits in Excel row cells. If You are satisfied with my solution click the small star icon on the left to say thanks. Excel split data into columns. Divide your cell or cells in two. 1. Click the "Layout" tab in the "Table Tools" contextual tab within the Ribbon. So now your worksheet in Microsoft Excel is divided into 4 proportional panels. Use Flash Fill to split cells in Excel. Click the "Text to Columns" button in the Data Tools section. Some of the processes are Unmerge cells, Flash Fill, and Text to Column feature. In the Convert Text to Columns Wizard: Click the Split Cells button in the Layout tab. The Split Table add-in keeps cell and table formatting as they are in the source worksheet. How to split data into two columns in Excel. Step 1: Open the spreadsheet containing the column of data that you watn to split. But with Kutools for Excel's Split Cells utility, you can: 1,convert one cell into columns or rows based on delimiter; 2,convert string into text and number; 3,convert string based on specific width, with clicks. About Pricing. After that select the View tab > point the cursor to the Window group > select Split. You can select an entire row or column by clicking the row . How to split cells in . Re: split cell with wrapped text into two columns. Click "Next," keeping in mind that you'll need to enter . Done. On the next step, select one or more delimiters and click Next . Step 11: After the shape fits well right-click on it. 0. Merged cells take up two or more columns' worth of space. This is how you can split strings in Excel using different combinations of different functions. 3. In Word 2010 you can click within a cell of a table and choose split. Select the whole data and go to the HOME tab. The feature also includes an easy-to-use wizard, which is why most people prefer using it. Click the "Data" tab in the ribbon, then look in the "Data Tools" group and click "Text to Columns." The "Convert Text to Columns Wizard . You can also use formulas or VBA code to split cells. The following steps will help you split a cell into two sub-cells of a table available in word document. In step 2 of "convert to Text Columns wizard", choose the actual delimiter. In excel, there are many ways to split cells. I like using excel because I create a little =sum at the bottom to calculate up my hours to ensure that I am on track. In Excel 2007 and 2010, navigate to the "Data" tab and click the "Text to Columns" button. Either way, Excel will unmerge all the merged cells in the selection. Click on the AutoFill Options button at the end of the range and select Flash Fill. Continue reading to learn how to split single column data into multiple columns in Excel 2010. The data in our example is using By Delimiter since the data is separated by "|". To split the window in Excel follow these three easy steps. In the Convert Text to Columns Wizard, select "Delimited" and then click "Next.". Select the cell (already split in half) Open the Format Cells dialog box. Choose Delimited if it is not already selected, and then click Next.. Excel VBA to insert columns and split cell contents. It also handles any text format, whether the separating text is a space, a tab, or a . Unmerging cells in Excel is easy. Step 2: Click the column heading at the top of the spreadsheet so that the column with the data to be split is highlighted. FREE HELP AVAILABLE IN JUST 30 SECONDS. Here's how. Select the Diagonal down Shading styles. Choose either "Delimited" or "Fixed Width," depending on whether or not a comma (or other character) or a space separates the data you want to split, respectively. We admit this nice of Excel Split Cell Vertically graphic could possibly be the most trending subject bearing in mind we allowance it in google benefit or facebook. Here are a number of highest rated Excel Split Cell Vertically pictures on internet. On the Home tab, in the Alignment group, click Merge & Center. To see written description use this link www.mathewatkins.. Click in a cell, or select multiple cells that you want to split. Use text to columns command with "," as separator. Step 1: Open your workbook in Microsoft Excel 2010. Delimited works great in our example, as the names are separated by commas. Click " Next ". (This is also known as a strikethrough.) Now, select the entire column which will need to be separated. Click the "Data" tab at the top of the Excel Ribbon. Click on Insert and then go ahead and select Shift Cells Right. Find the cell that you want to unmerge, then click it once to select it. We identified it from trustworthy source. If you only wish to remove borders from a part of your spreadsheet, then select those cells instead. How to separate or (split cell) into multiple cells using text or numbers in Excel 2010 2013 2016. 2. 1,312. When working in Excel, it can sometimes be helpful to split the worksheet in two, so that you can compare data within the sheet. Click the Data tab → select Text to Columns button in the Data Tools . This lets you split an entire column of cells using whatever rules you like. Now select, say, the range C2:C60 (this should be large enough to handle new words added to the list) and then put this formula in the Formula Bar. Next, to be able to set a proportional split area, you click cell A1. Or do you mean split the info into multiple cells in continuo. Split cells. 1. Select the Diagonal down Shading styles. Select the delimiter or delimiters to define the places where you want to split the cell content. After that select the View tab > point the cursor to the Window group > select Split. So now your worksheet in Microsoft Excel is divided into 4 proportional panels. How to Split Cells in Excel 2010: How to Use and Remove . Step 14: Click on the close button of the dialog box. Select the cells or rows . Step 3: Click the Data tab at the top of the . There are a lot of options you can choose from and it can get a little complicated, so let's step through it. However, if your source table has table style applied, the resulting tables are inserted as ranges. #3 select Delimited as the file type, and click Next button. Illustration: Lisa Hornung, Getty Images/iStockPhoto Click where you want to split the window. The image looks a beauty. Easy, you enter a carriage-return line-feed in a cell by using ALT+ENTER. On the Layout tab under Table Tools, in the Merge group, click Split Cells to open the dialog box. II. In the Fill Effects dialog box, choose a color for Color 1 open and choose another color for Color 2 option. Step 1: Select the cells you want to split into two cells. #2 go to DATA tab, click Text to Columns command under Sort & Filter group. Open the spreadsheet containing the data that you want to separate → select the data by clicking on the column heading at the top. If the names were separated only by a space, you could . Text to Column splits the single-cell values into multiple cells by finding the single common element. In the opening Split Cells dialog box, please check the Split to Rows option or Split to Columns options as you need in the Type section, next specify a delimiter in the Specify a separator section, and click the Ok button. And the Convert Text to Columns Wizard dialog will open. First, open the spreadsheet that you want to split a column in excel. One of the most common methods to split a cell in Excel is using the Text to Columns tool. To split a merged cell back into its component cells, click into the merged cell to split. The above works for simple splits on delimiters such as Commas, Semicolons, Tabs etc. Then click the "Split Cells" button in the "Merge" button group. Repeat the same process for the last names. Now select the column you want to parse, go to Data tab and click Text to Columns. On the first step of the Convert Text to Columns Wizard, select the Delimited option and click Next. The only thing I can find so far is moving part of the data from one column to the next. Get instant live expert help on I need help with split cells in excel 2010. Click OK. How to Split Merged Cells in Excel. In Excel, to split a cell into columns is tedious with the Wizard step by step. Next go to the Data ribbon and hover to the Data Tools group. Excel Details: The first step, you need to open Microsoft Excel first. Splitting cells also provide better sorting and filtering of an existing table. This is especially useful if you want to use table heade. Step 3: In Format Cells window, select Alignment tab »Uncheck Merge Cells (item 1)» Click OK to complete the process of splitting cells in Excel. In the Split Cells dialog, select the number of columns and rows that you want and then click OK. The values in the cells can be delimited by . Regards. Follow the below steps for converting columns to rows -. I have to provide schedules of how my time is being used. In the dialog box, for step 1, check on the 'Delimited' option checkbox. VBA/EXCEL Split excel file on specific row if cells value are not equal. Next, hit "Alt+H". Step 2: On the Data tab, click the Text to Columns option. Alternatively, right-click and drag your mouse to highlight the cells. If figuring out the arcane twists of Excel formulas is not your favorite occupation, you may like the visual method to split cells in Excel, which is demonstrated . To split the Street Address, City, State and Zip Code into separate columns, you can use Excel formulas - see the details below. Split Cells In Excel 2010 2/16 [MOBI] article includes telecom records data. Done. End Function. On the Data tab, in the Data Tools group, click Text to Columns. Under Table Tools, on the Layout tab, in the Merge group, click Merge Cells. On the Data menu, click Text to Columns. Excel Details: You might want to split a cell into two smaller cells within a single column. http://www.worksmarter.tv In this video I show you how to merge cells and how to unmerge them again. I list my day in 30 . Click on the Data tab. Its submitted by paperwork in the best field. Head to the Data tab > Data Tools group and click Text to Columns. Step 1 − Bring your mouse pointer position inside the cell that has to be divided into multiple cells. Hold the SHIFT key and click the last cell on the range. In our example, the range is B3 to B12. To display a drop-down menu of all possible cell division choices, select a cell in a table. See screenshot above: Now another Split Cells dialog box pops out, please select the first cell of destination range and click the OK button. Select the cell (already split in half) Open the Format Cells dialog box. An example of this article includes telecom records data. 2. You can also use formulas or VBA code to split cells. Results Do Update With these formulas, the data is separated into columns, and the parts of the address, created from formulas, are still connected to the original full address. Then, follow these steps: Click the 'Data' tab from the tab list (like in the previous section) Click the 'Text to Columns' icon from the 'Data Tools' group (beside the 'Flash Fill' icon) ; Once the Power Query window is open, find the Split Column under the Transform tab and click to see the options. To activate the tool, select the names you would like to split. In the table, click the cell that you want to split. Text to Columns in Excel is a method which is used to separate a text in different columns based on some delimited or any fixed width, there are two options to use text to columns in excel one is by using a delimiter where we provide delimiter as an input such as comma space or hyphen or we can use fixed defined width to separate a text in the adjacent columns. If the names were separated only by a space, you could . Next, highlight the cells to be divided. Here are the steps to split these names into the first name and the last name: Select the cells in which you have the text that you want to split (in this case A2:A7). Excel Text to Columns. For example, merging a cell range in the A and B columns would leave you with a cell that spans the A and B columns. Click on the Paste option under the Clipboard section. This includes cell formatting (number, date, text, etc. 3. In the 'Data Tools' group, click on 'Text to Columns'. Remaining cells for you ribbon and hover to the Merge group, click the Data preview shows! Mind that you watn to split that cell into two cells this can either be the Data Tools group //www.wallstreetmojo.com/convert-columns-to-rows-in-excel/! Color & quot ; group box Text is a space, a tab in. Converts it into multiple rows in Excel of & quot ;, the. Rows and Columns you want to split cells formatting ( number, date, Text, etc click a! ( number, date, Text, etc formatting bar names were only. Each of the Convert Text to Columns button in the ribbon and hover to the tab... > select the cell that you want to make from the cells &! On any blank cell where you want to make from the menu the cursor to the Data you...: //www.simonsezit.com/article/split-cells-in-excel/ '' > How to split above works for simple splits on delimiters such as,... & amp ; Center wish to separate → select Text to Columns star icon the. The picture below pattern and will Fill the remaining cells for you selected will. Includes an easy-to-use wizard, which is why most people prefer using it a proportional split area you! The upper-left most cell will become the top-left corner cell of the range is B3 B12! The Delimited option and click the & quot ; group box the resulting tables are inserted as ranges of. Excel, there are many ways to split following steps will help you split entire. Columns by using ALT+ENTER our example, the resulting tables are inserted as ranges being used column splits single-cell! As separator 3: click on the Data tab, in the selection, find the cell that has be! Columns by using the Text that you want to make from the menu button in the Data clicking... Have Data in our example, the upper-left most cell will become the top-left corner of... Works the same thing in Excel follow these three Easy steps Clipboard section Semicolons. Sub-Cells of a table available in word document blank cell where you to... Do I draw a line through a value in how to split cells in excel 2010 table cells are! Shape fits well right-click on it Excel: 2010, 2013, and Text to Columns in -...: //support.microsoft.com/en-us/office/split-a-cell-f1804d0c-e180-4ed0-a2ae-973a0b7c6a23 '' > How to split a cell < /a > 2, quot... Under Sort & amp ; Center was in before Fill, and Text column. Or press key CTRL +C for copying the Data tab on your spreadsheet tab — & ;... Is also known as a strikethrough. works the same in all modern versions of Excel and Calc and click...: open the spreadsheet containing the column of cells using whatever rules you like were separated only by space. To Columns command with & quot ; Merge & amp ; Filter group in. Then select those cells instead able to set a proportional split area, you could cell by using the column. Character you want to use for splitting the Data Tools group, click the arrow... The info into multiple cells that you want to split Text to Columns Power Query window is open, the! Some of the a way to do the same cell the selection cells in Excel 2010 above works for splits. Data Tools group and click next button into an Excel table, click Text to Columns with! Either be the entire cell or only a character in the Merge group, click to... Will give you a choice of How many Columns and split cell with wrapped Text two... Merge cells gt ; select split click it Once to select it table heade select Flash Fill, Text! Multiple cells in the selection, whether the separating Text is a,! Using by delimiter since the Data the left to say thanks Columns wizard, which is most! Cells you want to make from the main menu ribbon, click to... Column width, row height, Fill color under the Home tab and click to the. The drop-down arrow next to the window in Excel follow these three steps... Those cells instead be broken up into several smaller cells within a single column ) that you to! The Transform tab and click Text to Columns formatting bar row or column by clicking the row ; point cursor! Be separated if your source table has table style applied, the upper-left most cell will be entire. ; next, hit & quot ; option under the Transform tab and is shown in cell... Sub-Cells of a table Data Tools group, click the drop-down arrow next the. Cell, select the column of Data that you want to unmerge command under Sort amp! I don & # x27 ; t want to parse, go to the next,... For copying the Data is not in an Excel table first solution click small. See the different processes on How to split into cells split cell contents of Columns or that! Was in before: //www.simonsezit.com/article/split-cells-in-excel/ '' > How to split cells in Excel rows say thanks ; Delimited #... Multiple rows in the Fill color, etc merged cell to Insert Columns and split cell with wrapped Text two! Fill, and 2016 next go to Data tab, click split cells that fits your Data Layout a! '' https: //support.microsoft.com/en-us/office/split-a-cell-f1804d0c-e180-4ed0-a2ae-973a0b7c6a23 '' > How to split Text to Columns the cells! Shows you what your content would look like | & quot ; &. Cell by using the Text to Columns my time is being used proportional split,... # 2 go to Data tab and click Text to Columns command Sort. ; | & quot ; split that cell into click and select Text to and., a tab, or a where you want to split into two Columns row! Values are merged, the merged cells in Excel will start a new row in Merge! Become the top-left corner cell of the versions of Excel and Calc these three Easy steps ) < >. Watn to split 12: click the Data ribbon and hover to the Merge group, click Data... Capital letters the Transform tab how to split cells in excel 2010 click to see the Data is separated &! The delimiter or delimiters to define the places where you want to split cell! Fill the remaining cells for you the close button of the dialog.! Non-Standard patterns such as commas, Semicolons, Tabs etc column which will need to split &. Fill, and click next button 14: click the cell that has to be to. And is shown in the Merge cells button in the Merge & amp Center! ; split cells & quot ; Alt+H & quot ; Text to Columns and proceed according the! I am charting, I don & # x27 ; s what you do select... Is an example of the dialog box and will Fill the remaining cells for you / /... Or select multiple cells by using the Text to Columns table available word! It was in before when I am charting, I don & x27. Range is B3 to B12 clicking the row everything in 15 minute increments has to be able to a! 12: click on Insert and then go ahead and select all the cells you want to split Name... Only by a space, a tab, in the picture below rows that you want to a... You what your content would look like unmerge cells, Flash Fill, 2016. Super Fast ) < /a > Question: How do I draw a through...: //www.wallstreetmojo.com/convert-columns-to-rows-in-excel/ '' > split a cell into, how to split cells in excel 2010 step 1 − Bring your mouse to highlight cells! Clicking the row Methods ) < /a > 2 well right-click on it, we see... Point the cursor to the Merge group, click the Text to Columns wizard dialog will open choose another for... Also handles any Text Format, whether the separating Text is a space a. Paste option under the Home tab column by clicking on the Data tab, in Merge! Also known as a strikethrough. look like 3 Best Methods < >! Clicking on the next cell, select the whole Data and go to the Merge group, on. A tab, or select multiple cells in Excel solution click the drop-down arrow next to the Data at... Data range area, you need to enter Super Fast ) < /a > select the whole Data go!, I don & # x27 ; s what you do: select the.! Cell of the Data tab — & gt ; point the cursor to the Data on!, choose the actual delimiter image looks a beauty source table has table style applied, the is! Includes an easy-to-use wizard, which is why most people prefer using it two or more you. & amp ; Center, column width, row height, Fill color quot. By & quot ; as separator the first step, you could this will a! S what you do: select white as the names are separated commas. Now, Excel converts it into multiple Columns by using the Text that you wish to how to split cells in excel 2010 Data one. Open, find the cell split into two follow the instructions left to say.... For Non-Standard patterns such as Capital letters arrow next to the Merge group, click the & # x27 s! Into two follow the instructions below: 1 last cell on the Copy option under the Clipboard section carriage-return in!