How to Split Cells in Excel
We had recently seen how to join two cells in Excel , today we will see how to divide a cell into two, for this we will use the following example how is this? you will ask yourself, what we will do is having a data, for example a rut or a data separated by a script, pass the data to a cell each, well, let’s start with the following example:nnn
nnnnSuppose we want only the values that follow before the script, for this we will go to the data option and then text in columns, as we see below:nn
nnn Once we select the Text field in columns, we will get the following menu:nn
nnnnSelect Delimited because in this case, we want the data separated by the separator “-“:nn
nnnnTo finish we simply give you to next and in the next box we will place the cell format option, which comes to be something optional, so we simply give you to finish:nn
And with this we would already have the separate cells, as you see it’s not so complicated and it’s an excel function that everyone who works with the program every day should handle quite well. Well now we can see the result:nn
nn