Merge cells into one.
Our task today is the merging of two cells into one. So get started.
There's source code. See Figure 1
We need to merge and diametr1 diametr2 (as well as tovschina1 and tovschina2 and so on.
In your case it may be other data, but in the end you need to merge one value with another.) To get here is a final document (see Figure 2)
So get started.
Step 1.
Side of the table in the same row where there are two of our cell is a cell (1) and go to the option function Fx (2)
(2)
(On the left near the row of formulas), and find the function CONCATENATE (3)
Step 2
We have a window in which there is a slot with the names (Text 1, Text 2 and so on).
In these windows need to specify the ranges that we will attach.
As shown, the slot Text1 we select cell A2 (it contains 0) in the slot Text2 prescribes sign a dash (-)
in slot Text 3, select cell B2 (it contains 0)
That is:
Text 1 = "A2"
Text 2 = "-"
Text 3 = "B2"
,
Dash, we need to clutch when the cells between the sign of the first cell and the sign of the second cell was a division (there could be anything - a dash, a space, comma, and so on)
Step 3
Click OK. Now we have in the cell fusion of two cells. Then just hold out down the cell with the formula and all. Finish 0-0.
Ur friends! For the subsequent columns simply change the attributes in the text 1 and text 3.
(To merge more cells, add the following slots Text)
Thank you for your attention. Recipe formula (!!!!!= CONCATENATE (A2 ;"-"; B2) !!!!)
Ha ha. Wait a minute. And that's not all, but because we get a very ugly thing
such as 0-0 that is in two columns, we have two identical values.
Well, who needs a dual personality. Well you want to have you all been nice and now this split was not?
Without a rudder to do this? Then consider the extension.
In order not to overload the brain of one page, I will throw her onto a new page and here it will be a link
on it or about to clutch cells into one with subsequent correction using the IF ..
