But that doesn’t mean that you cannot split the contents of a cell and distribute the split portions into adjacent cells. Don’t let the fact that it’s a function intimidate you - it’s not as complicated as it sounds.Īs I mentioned earlier, there’s no way you can split a cell. Thinking that you can just merge the cells, you quickly realize that only the contents of one cell will be displayed in a larger cell - and that’s not the result you want! Instead, you’ll need to use the CONCATENATE function to quickly combine the contents of two or more cells into one cell. Other times, you might want to merge the contents of several cells into one cell. Instead, I merge several cells into one larger cell above the cells for which it will be the header. I often create such headers but use a different method than you’d expect because an individual cell simply cannot be split into smaller cells. For example, you may want to create a large header cell by splitting the cells below it into a number of smaller cells. It all depends on what you want to merge or split.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |