Unite 2 Excel cells for nesting
Today’s tutorial corresponds a Unit 2 excel cells 2007 or excel 2010 to be displayed in a single space. Suppose we have a field1 and a field2 as we see below, for this example we will use the cell with the name Paul and with the other cell Reds and we would like to make both cells stay in another as “Pablo Rojas”. It is a fairly simple tutorial, but it will certainly serve you enough if you don’t know how to do it.nn
nnnn Now if we wanted to show the contents of these two cells in a single, we would simply have to use the & connector, as follows
As you can see, now we would be looking at the A1&B1 cells together, now but if we wanted to add a space what it would be like? Well it’s just as simple, we just do the following:nn
nnnnAs you can see, simply adding a space between quotes, we already have the space we are needing. It is quite simple to do and sometimes one becomes much more complicated than necessary in this simple type of thing.nnIn short, to get the cells together, we simply have to do this:n
=A1&B1
If we want them to have a space or another character, simply
=A1&” “&B1
I hope this little tutorial has served you!