Hello, I created a table in Excel, and I would like to know how to Split a cell (cut it in half) because I have the "merge" function, but I can't find "split"... Thank you for your help

Instead of trying to split your cell G6 into 2 overlapping cells, you should: insert a new row 7 merge A6 and A7, B6 and B7 ... F6 and F7, H6 and H7 ... distribute your data between G6 and G7 (not merged) select rows 6 and 7 and go to Format/Alignment/Vertical/Center Retirement is great! Especially in the Caribbean... :-) ☻ Raymond ♂

Good evening Corentin, Take a look at Eric's and Vaucluse's contributions, posts 1 and 2, and then post 4 if you want to join in!! http://www.commentcamarche.net/forum/affich 3774297 separate excel cell by diagonal and I hope it will help you. -- Argitxu

Good evening, you can't split a cell in Excel, it's not like in Word. Eve

if you can with Excel 2007, I don't remember about 2003.

You should create your table with Word and then you will be able to split the cells.

You insert a column and merge all your cells except the one you're interested in lol Long live tinkering ;-) !

hello it's a bit late, but the solution is in the help section. It might help those who stumble upon this forum thanks to Google: Click on the merged cell. In the Format menu, click on Cell, then on the Alignment tab. Uncheck the Merge Cells checkbox. yep, it's that simple...

Hello, you just need to select the column, then: DATA tab CONVERT FIXED WIDTH define the splitting and choose the number of splits for the text 1, 2...x columns finish it. and there you have the split.

It's FALSE! The Convert command is not a cell splitting tool: it distributes the content of one cell across adjacent cells, while also overwriting their content, which is quite annoying! Post #22, just like post #23 from larbi dz, gives a false answer to the question asked, which has already received all the useful explanations. Gentlemen, test your solutions before proposing them... -- Retirement is nice! Especially in the Caribbean... :-) ☻ Raymond ♂

Hello, I have the REAL solution!!! If you want to split a cell, here’s what you need to do: 1- Go to the "Home" tab, 2- Next to Alignment, click on the small arrow. 3- A dialog box will open 4- Stay on the "Alignment" tab 5- Look for "Text Control" 6- Uncheck the box "Merge cells". There you go! It removed the merge. Best regards, Marianne

Hello, splitting a cell was indeed an option in previous versions of Excel... and the button still exists today. It is part of the many options that are not accessible from the ribbon. (right-click on the ribbon: customize the ribbon, you can indeed find the Split button to add to the ribbon). However, it is useless as it only serves to unmerge two cells that you had already merged. It is impossible to simply split a cell like that. Unfortunately, it leads to very tedious manipulations. ->> You need to insert a column next to it, then you merge the cells that you didn't want to split, yes line by line, otherwise everything will merge together...

Split a cell in Excel : CCM

11 answers

Answer 1 / 11 - Best answer
The best answer is the one that has been validated by our teams.
Raymond PENTIER Contributor
Instead of trying to split your cell G6 into 2 overlapping cells, you should:
- insert a new row 7
- merge A6 and A7, B6 and B7 ... F6 and F7, H6 and H7 ...
- distribute your data between G6 and G7 (not merged)
- select rows 6 and 7 and go to Format/Alignment/Vertical/Center
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂
40
1. Kilimanjaro
  
  Not a bad beast! :)
  Thank you
  
  0
2. So
  
  I took a while to understand, but I got it! Thank you!
  
  0
3. nicoelectro
  
  Thank you Raymond, thanks to you I was able to get by in two clicks.
  I don't understand why some people are still looking for the solution...
  
  3
4. Pauline
  
  I don't understand anything at all of this gibberish, I still haven't figured out how to merge cells on Excel with a Mac...
  
  0
5. Raymond PENTIER Contributor
  
  @PaulineNormal!
  Not only did you never ask for it, but it's also not the subject of this discussion, which is aimed at splitting, not merging!
  
  0
Answer 2 / 11
kromechant
You insert a column and merge all your cells except the one you're interested in lol

Long live tinkering ;-) !
23
Answer 3 / 11
evevdll
Good evening,
you can't split a cell in Excel, it's not like in Word.
Eve
19
1. larbi dz
  
  if you can split them. In the menu, click on "data" then "convert", select the cells to split and then next... good luck larbi
  
  0
2. anonyme
  
  @larbi dza huge thank you Larby!
  
  0
3. william
  
  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.
  
  0
4. Raymond PENTIER Contributor
  
  @williamWould you mind sending us a file containing your demonstration?
  
  0
5. ALADINTN
  
  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.
  
  0
Answer 4 / 11
Raymond PENTIER Contributor
It's FALSE!
The Convert command is not a cell splitting tool: it distributes the content of one cell across adjacent cells, while also overwriting their content, which is quite annoying!
Post #22, just like post #23 from larbi dz, gives a false answer to the question asked, which has already received all the useful explanations.
Gentlemen, test your solutions before proposing them...
--
Retirement is nice! Especially in the Caribbean... :-)
☻ Raymond ♂
17
1. kasfipasherov
  
  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?
  
  0
2. Raymond PENTIER Contributor
  
  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) ...
  
  0
Answer 5 / 11
Excel c'est plus fort que toi
Hello,

you just need to select the column, then:

DATA tab
CONVERT
FIXED WIDTH

define the splitting and choose the number of splits for the text
1, 2...x columns

finish it.
and there you have the split.
3
1. ninou
  
  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.
  
  0
2. Jed14
  
  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
  
  0
3. Raymond PENTIER Contributor
  
  And what if by chance (you never know, in a spreadsheet) he wanted to use this data to perform operations?
  
  0
4. Jed14
  
  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? :-)
  
  0
5. sarah
  
  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 :)
  
  0
Answer 6 / 11
Anonymous user
Good evening Corentin,

Take a look at Eric's and Vaucluse's contributions, posts 1 and 2, and then post 4 if you want to join in!!
http://www.commentcamarche.net/forum/affich 3774297 separate excel cell by diagonal

and I hope it will help you.

--

Argitxu
2
Answer 7 / 11
zazouu14
if you can with Excel 2007, I don't remember about 2003.
2
1. evevdll
  
  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
  
  0
2. zazouu14
  
  @evevdllYes, it's in the View tab, and on the left it says Split.
  
  0
3. evevdll
  
  @zazouu14Are you talking about the 2007 version or an earlier version?
  
  0
4. zazouu14
  
  @evevdll2007
  
  0
5. Raymond PENTIER Contributor
  
  @zazouu14Oh, là, là! It's about splitting the sheet into 4 sections, not splitting a cell! ...
  --
  Retirement is great! Especially in the Caribbean ... :-)
  ☻ Raymond ♂
  
  0
Answer 8 / 11
zazouu14
You should create your table with Word and then you will be able to split the cells.
2
Answer 9 / 11
sorcha
Hello,
splitting a cell was indeed an option in previous versions of Excel... and the button still exists today. It is part of the many options that are not accessible from the ribbon.

(right-click on the ribbon: customize the ribbon, you can indeed find the Split button to add to the ribbon). However, it is useless as it only serves to unmerge two cells that you had already merged. It is impossible to simply split a cell like that. Unfortunately, it leads to very tedious manipulations.

->> You need to insert a column next to it, then you merge the cells that you didn't want to split, yes line by line, otherwise everything will merge together...
1
1. Raymond PENTIER Contributor
  
  "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!
  
  0
2. sorcha
  
  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.
  
  0
3. Raymond PENTIER Contributor
  
  @sorchaMore interesting? No! It’s my passion, it’s my only goal in life! I have nothing else to do all day...
  Especially when people come back to a discussion that took place 8 years ago, where everything has already been said, and the initiator has classified it as resolved...
  
  0
4. sorcha
  
  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.
  
  0
5. Raymond PENTIER Contributor
  
  @sorchaI'm not alone, don't worry!
  Am I annoying everyone? Where are the results of your inquiry? For now, you are the only one being bothered by my comments.
  And you won't be long in receiving complaints from people who are starting to get tired of your own digressions...
  
  0
Answer 10 / 11
Marianne
Hello,

I have the REAL solution!!!

If you want to split a cell, here’s what you need to do:

1- Go to the "Home" tab,
2- Next to Alignment, click on the small arrow.
3- A dialog box will open
4- Stay on the "Alignment" tab
5- Look for "Text Control"
6- Uncheck the box "Merge cells".

There you go! It removed the merge.

Best regards,
Marianne
-1
1. Marianne
  
  in Excel!
  
  0
2. Marianne
  
  First, click on the boxes to unmerge.
  
  0
3. Raymond PENTIER Contributor
  
  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...
  
  0
4. Visiteur
  
  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.
  
  0
5. Raymond PENTIER Contributor
  
  @VisiteurRe-read the question asked: Your answer is completely off-topic!
  And it's another unnecessary "blah."
  
  0
Answer 11 / 11
riki ki
hello
it's a bit late, but the solution is in the help section. It might help those who stumble upon this forum thanks to Google:

Click on the merged cell.
In the Format menu, click on Cell, then on the Alignment tab.
Uncheck the Merge Cells checkbox.

yep, it's that simple...
-2
1. Raymond PENTIER Contributor
  
  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...
  
  0
2. zazacool
  
  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.
  
  0
3. Raymond PENTIER Contributor
  
  Read the post from November 2, 2008, at 8:15 PM
  https://forums.commentcamarche.net/forum/affich-9215701-fractionner-une-cellule-sous-excel#10
  
  0
4. Evaan
  
  Comment not entirely useless, I was looking for how to split a merged cell and I came across this, thanks!
  
  0
5. Kazuya
  
  Oh, it's okay kids, it came from a good intention on his part anyway!
  
  0

Split a cell in Excel

11 answers

Sms, how to insert a blank line between two paragraphs

Kb5124010 update issue tracker

Change ip address

How to find a phone number

Sea salt and laptop

Galaxy s4 tablet stuck on startup

Disable microsoft apps

Almost full ink absorber pixma ts8350 - how to do it

Emails that can no longer be accessed

Tiny11 installation