God, I just LOVE self-appointed experts who know what's best for everyone else. If I didn't have a practical use for splitting a cell in Excel, I wouldn't have gone looking for a solution and I never would have found this post. Just because YOU don't have a need for it doesn't make it of "no practical use". You must work at Microsoft, where the philosophy is "take it or leave it - what the customer wants is of no concern".

Funny how I'm only trying to split a cell to work a round a limitation of Excel that Open Office and Libre Office do not have. That limitation is only one hyperlink per cell. Microsoft obviously doesn't see it as a limitation, and I suppose you don't either. The only workaround is to use mulitple cells, but I'll be damned if I'm going to create extra columns for the appearance of split cells, then have to merge all those cells in every other row in the spreadsheet (it's at 757 rows and counting) to get them back to the single cell I need.

You may say Excel isn't the proper tool for what I'm trying to do, and that I should use a Word table instead, but in that case please tell me how to make a Word table with 42 columns (and counting) by 757 rows (and counting). And, I need to be able to add rows and columns without affecting the size/position/formatting of the existing rows and columns. Seems like Excel is the right tool for this job, except for the hyperlink limitation. I'd use Libre Office in a heartbeat, but this is at work and I'm constrained to using Office.

In any case, get off your high horse and open your mind; just because you don't want to do something doesn't mean anyone who does is foolish. Quite the opposite, in fact.