Handy One Liners

I have a few:

Please Login or Register  to view this content.

Here's a new one I picked up recently from another user

Please Login or Register  to view this content.

I hope Rick Rothstein sees this thread, as he used to come up with some nifty one-liners in a forum I used to subscribe to.

Pete

Originally Posted by Gregor y

add r/l-trim as a cell function

Please Login or Register  to view this content.

You can do these with regular Excel formulas...

Left Trim (normally entered)
====================================
=MID(A1,FIND(LEFT(TRIM(A1)),A1),LEN(A1))

Right Trim (normally entered)
====================================
=LEFT(A1,FIND("|",SUBSTITUTE(A1,RIGHT(TRIM(A1)),"|",LEN(A1)-LEN(SUBSTITUTE(A1,RIGHT(TRIM(A1)),"")))))

Right Trim (array entered)
====================================
=LEFT(A1,MAX((MID(A1&REPT(" ",99),ROW($1:$99),1)<>" ")*ROW($1:$99)))

Hey Pete,

Were the one-liners I posted the other day those that you had in mind or were you thinking of other old one-liners I may have posted? The real pity is a ton of one-liners I posted to the old Visual Basic and Excel newsgroups (not forums) were lost when Microsoft shutdown their newsgroup servers quite a few years ago now. When those servers were still active, searching for my name brought up literally 25,000+ postings by me and 2,000 to 3,000 of those posts were one-liners (lots of duplicates in them, of course). With very, very few exceptions, they are all gone.

Hi Rick,

It was on the Code Cage Forum where I particularly became aware of your one-line solutions, but sadly that too is now defunct.

Pete

Originally Posted by Pete_UK

Hi Rick,
It was on the Code Cage Forum where I particularly became aware of your one-line solutions, but sadly that too is now defunct.

I used to think that once posted on the web, it would be there forever. That perception changed when Microsoft closed their newsgroup servers oh so many years ago and an unbelievably large number of posting were lost forever. Since then, I have seen many other sites close down, like Code Cage did, also taking with them large amounts of postings containing extremely useful postings that also become lost forever. The real shame is "newbies" to whatever field can no longer benefit from these now lost posting as they, of course, will not show up in any online searches any more.

Originally Posted by Gregor y

If I was on 365, I'd be so tempted to try and turn these into Lambda functions.

I have not been able to fool around with Lambdas yet as I am having trouble getting 365 to load on my computer... I install it, it appears to go through the correct procedure but my existing copy of 2019 always remains afterwards, every time. When I can find time, I'll have to contact Microsoft to see if someone can help me fix whatever is blocking the install.

cool, thank you

@Rick Rothstein, do you remember your username & password for

Do you remember any of the names/sites for the microsoft newsgroups?

Originally Posted by johnnyL

@Rick Rothstein, do you remember your username & password for

No, but I found my link to The Code Cage and it now triggers a "This is a known dangerous webpage. It is highly recommended that you do NOT visit this page." warning from my Norton Antivirus software. So, apparently, someone with bad intents to their URL after the Code Cage closed down.

Originally Posted by johnnyL

Do you remember any of the names/sites for the microsoft newsgroups?

No, sorry, but I don't. The last time I did anything with newsgroups (where names might still have existed) was at least 3 computers ago.