Look Who it Was Random video

Excel - Mailbag Answers - Split Cell - Episode 802

248 views · Published 15 January 2009 · 4:01 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Mailbag Answers - Split Cell.

Welcome back to another episode of the MrExcel netcast. In this episode, number 802, we will be diving into the mailbag and addressing some of the most popular questions and suggestions from the last 10 episodes, 790 through 799. These episodes generated a lot of mail and we are excited to go through all of them with you.

In episode 790, we discussed how to create a split cell. We received a lot of great ideas from our viewers, including one from Brad who suggested using a bold outline and a diagonal line to split the cell. Another idea came from Mario, who used left and right justification to create a line between two cells. While these methods work, they can be tedious to copy and paste. My personal favorite was from Tony, who used a simple concatenation formula to create a functional, if not as visually appealing, split cell. Another great suggestion came from Stephan, who used a combination of hiding cells and the repeat function to create a clean and professional-looking split cell.

In episodes 795 and 797, we discussed the issue of using the fill handle to extend a series of numbers while maintaining the correct borders. Our viewers came up with some clever solutions, including using the ROW function instead of typing in a 1, and simply changing the number to 2 to avoid the issue altogether. Sometimes, the simplest solutions are the best.

In episode 798, I presented a complicated solution for entering dates in a specific format. However, many viewers pointed out that it may be easier to simply teach people to enter the data differently, such as using 7/2008 instead of 07/08. However, in some cases, like with legacy systems, it may be necessary to stick with the original format. As always, we appreciate all the suggestions and feedback from our viewers.

Thank you for tuning in to this episode of the MrExcel netcast. We hope you found these solutions helpful and we look forward to bringing you more tips and tricks in the future. Don't forget to subscribe to our channel and hit the notification bell to stay updated on all our latest videos. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Episodes 790, 795, 797, and 798 generated a lot of e-mail. We will review different ways to create split cells, copy without borders, and type months and years. Episode 802 will show you how.

Table of Contents:
(00:00) Introduction to episode 802
(00:18) Recap of previous episodes (790-799)
(00:28) Split cell methods (Brad's idea, Mario's idea, Tony's idea, Stephan's formula)
(01:52) Using =ROW(A1) instead of 1 for FILL WITHOUT FORMATTING
(02:31) Simpler solution for FILL WITHOUT FORMATTING issue (Tony's idea)
(03:01) Alternative solution for entering dates (using 7/2008 instead of 08/08)
(03:14) Training issue with legacy system and VBA code solution
(03:36) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Adjusting split panes in Excel
Computer America Show
Excel freeze panes
Excel split icon
Excel tips and tutorials
MrExcel netcast episodes
MrExcel studio
Pivot table analysis
Split panes in Excel
Spreadsheet tips and tricks

This video answers these common search terms:
Complicated way to format dates in Excel
Concatenation formula in Excel
Drawing diagonal line in Excel
Excel netcast from MrExcel
Excel tips and tricks
Filling without formatting in Excel
Hiding numbers in Excel
Legacy system in Excel
Split cell in Excel
Training issue in Excel
Typing dates in Excel
VBA code in Excel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152073/

More from this channel