• Skip to main navigation
  • Skip to main content
  • Skip to footer

Niall Best's Blog

Thoughts on programming and technology

Category: Excel

Remove multiple CR LF characters from the end of text strings in SQL

Posted on: 20 April 2016 Last updated on: 20 April 2016 Written by: Niall
Data entry, it’s where users love to copy and paste. Especially when their text is nicely arranged with multiple spaces, cartridge returns and line feeds amongst other special character formatting. In a perfect world this would be captured during input…
Continue reading “Remove multiple CR LF characters from the end of text strings in SQL”…

Find max or min values from a list of duplicates in Excel

Posted on: 18 February 2016 Last updated on: 18 February 2016 Written by: Niall
In Excel sometimes you will need to find either the first or last value from a mixed list of values that also include duplicates. Later versions of Excel feature a Remove Duplicates button under the Data tab in the ribbon. …
Continue reading “Find max or min values from a list of duplicates in Excel”…

Search

Recent Posts

Barcode processing PDF files

Use open source applications combined with PowerShell to process barcodes from PDF files.
Continue reading “Barcode processing PDF files”…

Repair, not replace – Herman Miller Aeron

I think the level of disposability in modern lifestyles is a genuinely sad thing. Driven on no doubt by globalisation and consumerism. Thankfully there are still a few areas where one can repair a product to further extend it’s useful…
Continue reading “Repair, not replace – Herman Miller Aeron”…

Dell U2413 Monitor turning off hardware fix

I think Dell make a great monitor; I’ve been buying Dell 24” monitors ever since the brilliant 16:10 aspect 2407wfp. However, the more recent Dell U2413 appears to have a rather serious issue where it will turn off after extended…
Continue reading “Dell U2413 Monitor turning off hardware fix”…

Achieve full open NAT with port forwarding for Xbox live via Opnsense

How to achieve full open NAT status with Xbox Live with Opnsense without using UPnP
Continue reading “Achieve full open NAT with port forwarding for Xbox live via Opnsense”…

APC Back-UPS Pro 900 battery refresh

(applies to the BR900GI model as well as other in the range, 550GI, 1200GI & 1500GI) Here is a writeup on how to recondition your UPS with cheaper standalone batteries rather than simply buying the manufacturers replacement pack. My UPS…
Continue reading “APC Back-UPS Pro 900 battery refresh”…

Categories

.Net 365 ASP.net Azure Backups Cars Cloud Computing Community Conference Draytek email Excel Exchange Server Firmware FTP General Hardware Hyper-V Microsoft Musings Networking Opnsense PowerShell RedGate Review Security Servers SharePoint SQL SQL Server Synology Testing Travel VoIP VPN WCF Windows Xbox

Disclaimer

The views and ideas expressed in this, my personal blog, are mine and do not represent those of my employer. Any comments are the sole view of the user who made them. Comments are moderated.

Recent Posts

Barcode processing PDF files

Use open source applications combined with PowerShell to process barcodes from PDF files.
Continue reading “Barcode processing PDF files”…

Repair, not replace – Herman Miller Aeron

I think the level of disposability in modern lifestyles is a genuinely sad thing. Driven on no doubt by globalisation and consumerism. Thankfully there are still a few areas where one can repair a product to further extend it’s useful…
Continue reading “Repair, not replace – Herman Miller Aeron”…

Dell U2413 Monitor turning off hardware fix

I think Dell make a great monitor; I’ve been buying Dell 24” monitors ever since the brilliant 16:10 aspect 2407wfp. However, the more recent Dell U2413 appears to have a rather serious issue where it will turn off after extended…
Continue reading “Dell U2413 Monitor turning off hardware fix”…

Achieve full open NAT with port forwarding for Xbox live via Opnsense

How to achieve full open NAT status with Xbox Live with Opnsense without using UPnP
Continue reading “Achieve full open NAT with port forwarding for Xbox live via Opnsense”…

APC Back-UPS Pro 900 battery refresh

(applies to the BR900GI model as well as other in the range, 550GI, 1200GI & 1500GI) Here is a writeup on how to recondition your UPS with cheaper standalone batteries rather than simply buying the manufacturers replacement pack. My UPS…
Continue reading “APC Back-UPS Pro 900 battery refresh”…

Categories

.Net 365 ASP.net Azure Backups Cars Cloud Computing Community Conference Draytek email Excel Exchange Server Firmware FTP General Hardware Hyper-V Microsoft Musings Networking Opnsense PowerShell RedGate Review Security Servers SharePoint SQL SQL Server Synology Testing Travel VoIP VPN WCF Windows Xbox

Disclaimer

The views and ideas expressed in this, my personal blog, are mine and do not represent those of my employer. Any comments are the sole view of the user who made them. Comments are moderated.

© 2023 Niall Best's Blog | Using Reykjavik WordPress theme. | Back to top ↑