![]() ![]() Repeat this for all of the columns in the preview window.Ĭlick the button to the right of the Destination box to collapse the popup window.Īnywhere in your workbook, select the cells that you want to contain the split data. If you don't want the default format, choose a format such as Text, then click the second column of data in the Data preview window, and click the same format again. A preview of the data appears in the panel at the bottom of the popup window.Ĭlick Next and then choose the format for your new columns. Or, check both the Comma and Space boxes if that is how your text is split (such as "Reyes, Javiers", with a comma and space between the names). Simply add empty columns, if necessary.Ĭlick Data > Text to Columns, which displays the Convert Text to Columns Wizard.Ĭheck the Space box, and clear the rest of the boxes. Also, ensure that are sufficient empty columns to the right-so that none of your data is deleted. Note: Select as many rows as you want, but no more than one column. Select the cell or column that contains the text you want to split. ![]() This is the opposite of concatenation, in which you combine text from two or more cells into one cell.įor example, you can split a column containing full names into separate First Name and Last Name columns:įollow the steps below to split text into multiple columns: ![]() You can take the text in one or more cells, and distribute it to multiple cells. Split text from one cell into multiple cells If you need to reverse a cell merge, click onto the merged cell and then choose Unmerge Cells item in the Merge & Center menu (see the figure above). To merge cells without centering, click the arrow next to Merge and Center, and then click Merge Across or Merge Cells. Cells formatted as a table typically display alternating shaded rows, and perhaps filter arrows on the column headings. Same functionality and look as columns, you just may need to create a new table for each page depending on your formatting preferences.If Merge & Center is disabled, ensure that you’re not editing a cell-and the cells you want to merge aren’t formatted as an Excel table. Just create a 2 or 3 column table with 1 row and then choose white as the color for the lines. Now we wait for columns….although my workaround will be good for most people. While Word may have the upper hand when it comes to formatting, Google Docs has it when it comes to ease of use and collaboration. You can quickly share out what you created with the world with a couple clicks. You can easily have a group all work on the same file at the same time and even include the teacher during the entire process, instead of just at the end. Google Apps are so much easier when it comes to collaboration and communication. I know Mircrosoft has opened up Office 365 to many in education for free, this might be too late for many who were tired of having to pay for it or to hear from their students that they had a different version at home than what we had at school. I like being able to easily share out and collaborate on a document without having to pay for it. While Word may have more editing features, I still like Google Docs as my document tool. I think Google did miss the fact that so many people wanted this, as was evident by how many times my tweet got retweeted and by how many people I follow on Twitter were tweeting the same thing. The thing is, even though I am a big fan of Google Apps due to what we can do with them with students (for free), this was a feature that was not necessary but is nice to have. I can hear those people who use Word yelling at all of those who are happy with this update that they could always do this in Word. This is a big thing for people who really want to format their tables in a certain way but were not able to do so before without a workaround using spreadsheets or another document type. You can also do this by highlighting those cells and then right-clicking to get the same options. ![]() You can merge cells by simply highlighting those cells, click on “Table” and then “Merge Cells”. You can find out more about the updates today at There are also some other updates but this seems to be the one that people wanted the most. This is a new update and is rolling out to all accounts as I type. Now I know many people would have assumed you could have done this before, they would be wrong. You can now finally merge table cells in a Google Doc. Google has come out with another update to Google Apps, which it does with regularity, and this one appears to be one that could seem small to many but according to my Twitter stream, it was a big one. ![]()
0 Comments
Leave a Reply. |