Contents not fully displayed

[terrypin]

Why doesn't cell b6 get fully displayed (as 'Saturday 21 January 2017'), stretching into column C, like the cells above?

Terry, East Grinstead, UK

 

[mole999]

> https://www.mrexcel.com/forum/excel-questions/979160-how-show-full-contents-cell.html#post4698168

Is this actually any different from the question in December ?

 

[Joe4]

Only string entries get stretched beyond the end boundaries of the cell. Numbers and dates do not.
Just expand column B to make it wide enough to display it.

 

[terrypin]

Thanks both.

@mole999: Guilty as charged! I knew I'd posted it before in an Excel Usenet newsgroup but I'd forgotten doing so here, sorry. Especially as I had a clearcut (albeit disapointing) answer. Premature senility suspected!

@Joe4: Can't do that because later rows use cols B - H for tables and other data.

Seems a surprising limitation IMO. I may try to use an OCR utility plus a script with my macro program. Or attempt a VBA macro.

Terry, East Grinstead, UK

 

[mole999]

reduce the font size or format as d/m/yy

 

[Joe4]

@Joe4: Can't do that because later rows use cols B - H for tables and other data.

Formatting is a common problem when you try to do too much on a single sheet. What works well for one section limits you in another. Of course, you could use multiple sheets or different columns, but that is pretty obvious, so I assume that you already have a good reason for not doing so.

Another option that may or may not work for you is you could highlight cells B6 and C6 and use the "Center Across Selection" formatting option, and it will show the whole thing.

 

[terrypin]

Thanks Joe, hadn't used that before. But...

 

[mole999]

OCR is designed to rebuild physical text from a picture, here you have the text in an optimal form ?

 

[terrypin]

OCR is designed to rebuild physical text from a picture, here you have the text in an optimal form ?

To get b6 in that screenshot I used OCR on the graphic text displayed bottom right of b6 in my earlier screenshot. (After using the macro I mentioned.)