minimise space in cell with a line break in the Date format

[Wad Mabbit]

I'musing Ctrl+J to create a line break in a date format

For instance
dddCtrl+JdCtrl+Jmmm;;;@

to produce
ddd
d
mmm

However, I get a wide indent, so much of the idea is wasted, like:
ddd
d
mmm

What I'm trying to do is to get date information into a cell as narrow as possible but still easily readable. Rows with bookings are usually 3 lines deep, hence the two line breaks.

I don't know what is causing the phantom spaces/indenting, but it's counter-productive. Any help on this?

 

[Alex Blakenburg]

Try this:
• Go into Format Cells > Alignment
• Turn Wrap text off (uncheck)
• Turn on Shrink to fit
• Turn Wrap text back on
You should now be able to shrink the column to suit the text without it turning into ####

 

[Wad Mabbit]

Try this:
• Go into Format Cells > Alignment
• Turn Wrap text off (uncheck)
• Turn on Shrink to fit
• Turn Wrap text back on
You should now be able to shrink the column to suit the text without it turning into ####

Wow, nice!

 

[Alex Blakenburg]

No problem. Glad I could help.

 

[Wad Mabbit]

No problem. Glad I could help.

Well, if you want a challenge, I'm trying to set up a multiple conditional lookup, but it's doing my head in!
I'm starting off with the info here:

Google Sheets: Use INDEX MATCH with Multiple Criteria - Statology

This tutorial explains how to use INDEX and MATCH with multiple criteria in Google Sheets, including an example.

www.statology.org

But just can't get it to work!
In the attached, row 519, I can look up Caz next lesson with this formula in K519"\:
=IF(G519="", "",IFNA(LEFT(TEXT(INDEX(A520:A$1731,MATCH(G519,G520:G$1731,0)),"dddd"), 3),"") & IFNA(TEXT(INDEX(A520:A$1731,MATCH(G519,G520:G$1731,0)), " d/m"),"") & CHAR(10) & IFNA(INDEX(B520:B$1731,MATCH(G519,G520:G$1731,0)),"") )

It gets me:
Thu 24/11
2:15-3:15

So it uses column G (Phone number) and finds the next future instance.

What I'm trying to do is to find a future instance that also has "LC" within text in row E (Details), e.g. Caz's next lesson that is also a test ('LC' stands for Lic encing Centre'), based upon the phone number (unique identifier).

If I can get that, then I think that I can work out how to test for "HPT" (Hazard Perception Test) anywhere in column E (Details) with that number match (Caz) so that I check if I have noted that Caz has done a HPT befopre the actual test day. I'm using column N for that.


Also, further bookings? It would be nice to have a list. Is that possible?. I'm using column S for that.

 

[Alex Blakenburg]

That's a very different question and will need a separate thread. You are more likely to get a response and get a better answer if you include an XL2BB of some sample data. (I can't even see LC in your screenshot although I may have missed it)

 

[Wad Mabbit]

That's a very different question and will need a separate thread. You are more likely to get a response and get a better answer if you include an XL2BB of some sample data. (I can't even see LC in your screenshot although I may have missed it)

That's fine, and yes, I haven't put LC in a cell. I'll creste a nrw thread and try XL2BB, though I haven't had luck with that yet.