Category Archives: Excel

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

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

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