Split a cell in Excel

if you can split them. In the menu, click on "data" then "convert", select the cells to split and then next... good luck larbi

To "unmerge cells in Excel:
a) select the (therefore the) affected cells
B) Right-click
C) Select "cut"
D) position yourself in the sheet on a cell outside the document being processed in an empty area or on an empty sheet
E) Right-click
Select "paste"
The affected cells in the document are then "released (reset to the width of the affected columns) and can be filled in as needed.
All that remains is to select the columns from the place where we "copied" the merged cell
and delete them.

On can also format the desired cell as a table in Word, copy and paste it into the cell to be split, and then adjust the adjacent cells to have the same width.

Hello, I'm struggling with this 2007 version to "simply" unmerge merged cells... It's pretty straightforward, isn't it? It should be just like in the 2003 version. In 2007, they've complicated everything and we waste a lot of time trying to find a simple command that has been widely used for ages by millions of people... And suddenly, it disappears..

How can I make the merged cells regain their original appearance?

It's you who complicates what isn't complicated and who looks for I don't know what just beneath your nose!
It's the same command that is used to merge and unmerge (like the Bold command or the Filter command) ...

Help, this manipulation is great, but what do I do when the data is not all aligned? I need to separate addresses and of course, since nothing is aligned, it creates a lot of columns for me.

Hello,
The question is interesting.
Considering that one cell = 15 minutes, it can correspond to typical needs.
Otherwise, I tried to fiddle something together: it's doable in Excel 2007 by clicking on Insert > Shapes > Rectangles. Then, you stretch the rectangle to half of the cell but you have to make sure that the rest of the column is done the same way.
Best regards
Jed14

And what if by chance (you never know, in a spreadsheet) he wanted to use this data to perform operations?

Ouch! It's getting complicated! Yes, it's true that with Excel 2007, any situation is possible. In this case, the "trick" of the rectangle doesn't prevent calculations: if we want to sum by selecting the half-cell, it's just that the entire cell is selected. This doesn't stop the calculation, but it's not ideal because we can't use the remaining half-cell for another calculation... Am I clear or not at all? :-)

A method I use is effective for splitting a cell in two and writing numbers in it: right-click on the cell => format cell => border => choose the diagonal.
This does not allow for actual splitting; it only gives a cell divided in the middle by a diagonal. But you can write and separate the numbers with a space until they are positioned on either side of the cell.
I hope this will help someone :)

With the previous versions, it wasn’t possible, but if on the other hand you say the opposite, please specify the solution.
I will check if it works for version 2007.
Eve

"It's only useless because it only serves to unmerge 2 cells that you had already merged"
Thank you; but this has already been explained in this discussion!

In reality, no, it hadn't been explained; we only talked about the "merge" box to uncheck, which is not the same as a "split" button that no one had mentioned the existence of until now!
So yes, it unfortunately has the same effect, but it might prevent some people from searching for this function for a while and then trying it out, for nothing, like I did.
P.S.: Given your many somewhat aggressive comments, you are clearly passionate about the matter, but personally, I don't care to stress over a forum discussing Excel features... there might be more interesting things to do with one’s life than criticize those trying to solve a simple problem.

I just said that not everything has been said... did that provide an additional solution? No. But could it prevent some people from looking in hidden options for an existing but ultimately ineffective function? Maybe, the proof is that I did it myself after reading your supposedly complete conversation. And the fact that it's 8 years old has nothing to do with the fact that you're bothering everyone with your comments (which are even more useless than mine!), plus the problem is just as relevant now as it was 8 years ago.
So I'll leave you to enjoy this little forum game where we pick fights for no reason, I've never been interested in that.

in Excel!

First, click on the boxes to unmerge.

No, Marianne! No!

It's not about merging two cells, but about splitting one: ...
I had already mentioned it here https://forums.commentcamarche.net/forum/affich-9215701-fractionner-une-cellule-sous-excel#18 almost two years ago...

The solution is really very simple. A lot of fuss for nothing.
Just select the column and copy the content. Open a text file (.txt) and paste everything in it, then save it.
Next, open a new Excel file or tab.
Go to Menu/Open and select the .txt. The import wizard will open. Check Fixed width, then Next, place a separator where desired, then Next and finally Finish.
There you go, as many columns as desired, all that's left is to copy at your leisure.

Too much, even: That is not at all the problem that was raised!
It is not about separating 2 merged cells, but about splitting a single cell...

Yes, it's about splitting a cell into two, and I need to know how to do it please, thank you for helping me quite quickly.

Read the post from November 2, 2008, at 8:15 PM
https://forums.commentcamarche.net/forum/affich-9215701-fractionner-une-cellule-sous-excel#10

Comment not entirely useless, I was looking for how to split a merged cell and I came across this, thanks!

Oh, it's okay kids, it came from a good intention on his part anyway!