How to split cells in Excel | 4 ways to make your data usable | Excel Off The Grid

[@johnboffin476]

Thanks Mark, you are great a teacher.

[@ExcelOffTheGrid]

Thank you. I appreciate that. 😁

[@reddysiddiqui]

Hi Mark- Thank you. This was explained very well.

[@ExcelOffTheGrid]

Thanks you, very kind of you to say. 😀

[@abdulhamidalhaddadi2255]

Its realy helpfull, Thank you sir

[@ExcelOffTheGrid]

You’re welcome.

[@digray6732]

Amazing, thank you, i lovve excel :)

[@ExcelOffTheGrid]

Glad I could help 😀

[@wrzq]

Thank you so much for this tutorial, you made my day!

[@ExcelOffTheGrid]

You’re welcome. Glad I could help. 😀

[@pimaghartimagar5252]

Thank you sir

[@cogwheelLearning]

Really well explained and easy to follow! Thanks

[@ExcelOffTheGrid]

Thank - I appreciate that :-)

[@roninalden6956]

@Madden Sterling yea, been watching on flixzone} for months myself :)

[@YoussefTsun]

Nice vid

[@ExcelOffTheGrid]

Thanks.

[@hrmailbackup280]

thanks very helpful

[@ExcelOffTheGrid]

You’re welcome 😀

[@Kamekichi486]

I’ve been searching for this method for so long and now I know how to separate the cell😆 Thank you so much for your explanation and please keep upload those videos 🤩

[@ExcelOffTheGrid]

You’re welcome 😊

[@wayneedmondson1065]

Hi Mark. Thanks for lesson on splitting data. Very interesting and well explained. Thanks for sharing :)) Thumbs up!!

[@ExcelOffTheGrid]

Thanks Wayne - I appreciate that. I’m trying to be more consistent with videos over the coming months. So hopefully there will be some more stuff to interest you going forwards. 😀

[@wayneedmondson1065]

@@ExcelOffTheGrid Excellent!! Looking forward to it :))

[@jerilester6363]

I don’t need to know how to split the information. I need to Know how to actually JUST SPLIT THE CELL. Divide a cell in one column into two or more cells. Why is this so hard to find??

[@ExcelOffTheGrid]

That isn’t how Excel works. It’s not a presentational tool, Rows and Columns actually mean something in Excel. So you can’t find it because you can’t do it.

[@nemod3338]

But this is not splitting of a cell. It is splitting of the DATA within a cell and creating an extra cells on the side. The main question everyone is looking for is HOW TO PHYSICALLY SPLIT A CELL (in two, three) IN EXCEL? Which is not possible. How hard is for Microsoft to implement simple rule like "Cell B" becomes "Cell Ba + Cell Bb" after splitting within the same "Cell B"?

[@ExcelOffTheGrid]

Sorry, but that sounds like a terrible idea. Most users already struggle structuring data correctly; adding the concept of a partial columns and it will be even more of a mess. If you want to split a cell in that way, just insert a column, and use the techniques in the video to populate that column.

[@bejai1962]

Physically split a cell? Honestly I got confused trying to understand what you mean.

[@userrjlyj5760g]

@@bejai1962 Yeah, he is right and what he said is just fine! I want to do that and that's how I ended up here due to the misleading title of the video!

[@CaribouDataScience]

How many columns to the left will Flash Fill look?

[@ExcelOffTheGrid]

That's in interesting question. I actually don't know. Sounds like a bit of trial and error might be required.

[@jagadeesheedala5390]

Hi Mark! Thanks for the lesson on splitting data 🥰... But I need to split one data cell which contains First Name, Last name, Address, City, State, Zip Code, Country and Mobile Number to different columns like First Name in First cell, Last Name in Second cell and followed by Address like that remaining.. Can you make a video on this please...

[@EraseTime]

Can you split one cell in the same cell? or you need to add a row? Im not english but what im trying to say is if it is possible to slice in half one cell but not in columns but horizontally

[@ExcelOffTheGrid]

You can add a line break into a cell. Is that what you mean?

[@EraseTime]

@@ExcelOffTheGrid yeah like a hamburger

[@ExcelOffTheGrid]

@@EraseTime Yes, it’s possible. But too long to answer for all methods. Which method do you wanting to do it with?

[@EraseTime]

@@ExcelOffTheGrid the easiest one

[@ExcelOffTheGrid]

The easiest is when Flash Fill, use Alt+Enter to create a line break in the cell.

[@archimangla9658]

Hey!! Can you just tell how to slice a cell into two? Any method except the flash fill>alt+enter one Pleaseee

[@ExcelOffTheGrid]

Isn’t that what the video shows? Or do you have a specific scenario? Can you share a bit more info about what you’re after.

[@AntipodesAnnie]

@@ExcelOffTheGrid if it's what I'm trying to do is not moving the info to a new cell but to split an existing cell in half so that it doesn't affect the formatting of the cell above it. I have a restricted format, the cell size cannot be changed but I need to put more information. I cannot insert new cells so I need to be able to split a cell in half and maintain the same size. I know I can insert a new cell then merge all the other cells above it to main the formatting but if there is an easier way, it would be good to know.

[@ExcelOffTheGrid]

@@AntipodesAnnie Excel isn’t like Word or PowerPoint, which are both presentational tools. Excel is for calculations, therefore the rigid structure of rows and columns is critical to how it works. So you can create a new column and merge some cells across to give the same end result, but you can split a cell in the same way as PowerPoint or Word. Sorry. 😬

[@ImagesOfBurscough]

This is exactly what i need too@@AntipodesAnnie

[@queryhsje7514]

Hi, thank you for the video, how about if we have a middle name, what formula or function to use? Thanks

[@userrjlyj5760g]

that has nothing to do with "split cell" ... you should put the title as split data inside cell instead!!!

[@deepakpatwa7157]

Can we fixed the second word of the name at specific intervals of that cell in excel

[@ExcelOffTheGrid]

Can you give an example?

[@syedzain216]

You should have shown with 3 names instead of 2

[@ExcelOffTheGrid]

Thanks for the feedback. If I ever update the video I’ll take it onboard.

[@hhgh1041]

Hi uncle mark

[@ExcelOffTheGrid]

Hello FJ - Thanks for Subscribing. 😁

[@danielrivera5759]

This title is missleading. This is splitting data in a cell. If splitting a cell, which this is NOT, can't be done as I've seen mentioned in the comments, then at least correct your tittle. Thanks.

[@VIKTOR69]

why???

[@mrfaizankhan]

14 minutes videos for 1 small issue ? ridiculous !

[@ExcelOffTheGrid]

Lol!! If only it were a small issue. Text data rarely follows structured patterns, and can cause some of the biggest data integration issues. I’m just trying to share the tools that might help based in a simple scenario. Things can get a lot more complex with fuzzy matching and and pattern matching algorithms required.

[@Xman-lg7qg]

you're not splitting ONE cell- anoying

[@ExcelOffTheGrid]

In Excel a cell is the smallest unit. So splitting a cell can only mean splitting the contents of a cell.

[@Xman-lg7qg]

@@ExcelOffTheGrid Thank you! i thought i seen something to have ONE cell in the middle of a document and in order not to insert another column the same cell can be splitted. Id there anything like that in excel?