Category Archives: Excel

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

Posted on April 20, 2016 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 →

Posted in Excel, Microsoft, SQL Server | Leave a comment

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

Posted on February 18, 2016 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 →

Posted in Excel, Microsoft | Leave a comment